how to change password?

[vinod]

Dear experts,
i'm getting problem with sql server 2000. actually i changed the service from automatic to manual, right from that day,sql server is not working on my machine.when i checkd in the properties of sql server registration, it is showing some around 8 letter password. actually i will connect with sa and password sa.

where should i change the password? is there any other solution?

or is it better to uninstall and install again? if so what about my databases?


please help me in this regard

[michelle]

Hello vinod,

Go to the folder security;
Double click on the user;
Change the password (don't forget it!!!)
Pressing on the Ok button;
Repeat the password.

In principle, if you press as password of only one character, for security reasons sqlserver 2000 will show you as password 10 stars.

For testing create a new user and change the password.

Good luck,
Michelle.

[masdi2t]

on 'edit sql registration properties' window, use windows authentication first. after u've logon, change the password on Security->Logins section.

[yitiana]

You can use command prompt to change the password.

Osql -S yourservername -E 
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO