Friday, March 23, 2012

MSDE password change for "sa"

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,
DanIf 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|||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|||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

No comments:

Post a Comment