Re: running sp_password for MSDE upgrade
From: SQLServer Development Team[MSFT] (SqlDev@microsoft.com)
Date: 01/30/03
- Next message: Anthony: "SQL and MSDE patch"
- Previous message: Mike: "Database Security Certification"
- In reply to: Rick Hollinbeck: "running sp_password for MSDE upgrade"
- Next in thread: Rick Hollinbeck: "Re: running sp_password for MSDE upgrade"
- Reply: Rick Hollinbeck: "Re: running sp_password for MSDE upgrade"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "SQLServer Development Team[MSFT]" <SqlDev@microsoft.com> Date: Thu, 30 Jan 2003 11:27:47 -0800
Here's the syntax for changing the password, after you've logged into MSDE
as sa:
-------------------------------------------------------------
sp_password
Adds or changes a password for a Microsoft® SQL ServerT login.
Syntax
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]
Arguments
[@old =] 'old_password'
Is the old password. old_password is sysname, with a default of NULL.
[@new =] 'new_password'
Is the new password. new_password is sysname, with no default. old_password
must be specified if named parameters are not used.
[@loginame =] 'login'
Is the name of the login affected by the password change. login is sysname,
with a default of NULL. login must already exist and can only be specified
by a member of the sysadmin fixed server role.
-- Stuart Ozer
SQL Server Development
"Rick Hollinbeck" <rickh-msnews@westernwares.com> wrote in message
news:uWs3uTJyCHA.1420@TK2MSFTNGP12...
> Updating my full SQL Server to SP3 was easy because
> sql2ksp3 prompted me to enter a new non-blank sa password.
>
> I'm now trying to update the MSDE that was installed as part of my
> .NET development environment.
>
> After downloading sql2kdesksp3 and figuring out the proper setup command
> line to update the
> VSdotNET instance from the readme, setup won't run, telling me to set a
> non-blank
> sa password with sp_password.
>
> Dumb question: how do I do this? - readme doesn't say.
>
> Thanks
>
>
>
>
- Next message: Anthony: "SQL and MSDE patch"
- Previous message: Mike: "Database Security Certification"
- In reply to: Rick Hollinbeck: "running sp_password for MSDE upgrade"
- Next in thread: Rick Hollinbeck: "Re: running sp_password for MSDE upgrade"
- Reply: Rick Hollinbeck: "Re: running sp_password for MSDE upgrade"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
