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 regardHello 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.|||on 'edit sql registration properties' window, use windows authentication first. after u've logon, change the password on Security->Logins section.
No comments:
Post a Comment