471,573 Members | 1,032 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

how to change password?

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 13775
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,
Aug 28 '06 #2
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
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.