469,276 Members | 2,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,276 developers. It's quick & easy.

how to change password?

40
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
Aug 28 '06 #1
3 13722
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.
Aug 28 '06 #2
masdi2t
37
on 'edit sql registration properties' window, use windows authentication first. after u've logon, change the password on Security->Logins section.
Aug 29 '06 #3
You can use command prompt to change the password.
Expand|Select|Wrap|Line Numbers
  1. Osql -S yourservername -E 
  2. 1> EXEC sp_password NULL, 'yourpassword', 'sa'
  3. 2> GO
Aug 12 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by GregS | last post: by
1 post views Thread by eighthman11 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.