Re: MSDE password change for "sa"
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/16/04
- Next message: David: "RE: SQL 6.5 DB without a Master.dat"
- Previous message: MSchlaud: "Re: Escaping a comma in a LIKE statement"
- In reply to: Dan Kennedy: "Re: MSDE password change for "sa""
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Jun 2004 15:00:25 -0600
Yes...it will still work. That's what you would use to reset any
password when you are logged in as a sysadmin. Just pass null for the
old password. It doesn't mean the password is null. It means you
aren't supplying the old password.
-Sue
On 16 Jun 2004 11:26:10 -0700, dankennedy24@hotmail.com (Dan Kennedy)
wrote:
>But the current "sa" password isn't blank... will that statement still
>work? I login to the machine as a local admin and connect via the
>osql statement as the same ID as I logon to the machine with.
>
>Sue Hoegemeier <Sue_H@nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9plg@4ax.com>...
>> If you can login as an admin on the box and the
>> builtin\administrators group login was not removed or
>> modified, you will be logged in as a member of the sysadmins
>> server role. As a sysadmin, you can execute the following to
>> change the sa password:
>> sp_password NULL, 'NewSaPassword', 'sa'
>> Upgrading to SQL Server isn't too bad. Run the SQL Server
>> installation CD. You will be asked if you want to upgrade
>> your existing instance or install a new one. Choose to
>> upgrade.
>> For more detailed steps on upgrading, you can refer to the
>> SQL Server Books Online topic:
>> How to perform an edition upgrade within SQL Server 2000
>> (Setup)
>> http://msdn.microsoft.com/library/en-us/howtosql/ht_install_1d7y.asp
>>
>> -Sue
>>
>> On 15 Jun 2004 17:41:11 -0700, dankennedy24@hotmail.com (Dan
>> Kennedy) wrote:
>>
>> >Hello,
>> > If I can get into the default instance of MSDE using a Windows
>> >account (trusted connection) using 'osql -E' is it possible for me to
>> >change the 'sa' SQL account if I don't know the current password? The
>> >Windows account is a domain admin and local box admin if that matters.
>> > Also, can anyone point me to a Q article that will give me a step
>> >by step on how to upgrade from MSDE to SQL so I can get past this 2GB
>> >limitation?
>> >
>> >If anyone can answer these I am definitely buying beers!!
>> >
>> >Thanks,
>> >Dan
- Next message: David: "RE: SQL 6.5 DB without a Master.dat"
- Previous message: MSchlaud: "Re: Escaping a comma in a LIKE statement"
- In reply to: Dan Kennedy: "Re: MSDE password change for "sa""
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
