Password out of synch between W2K & Local SQL Server on my Worksation

[Fardude]

Hi,
I had this problem in version 7 and dont remneber How I solved it!!
I have installed a local SQL Server (2000 aka version 8) on my
Worksation (W2K), I have picked NT authuntication.
Everything was fine untill I changed my password. Now SQL server can
not start because it fails to login. The old password is embedded
somwhere and I cant egt to it!!!
My workstation is on a network, so the password is my network
password.
Everythinng is MS on our network.

Any help would be appreciated.

Thanks
Fardad

[Erland Sommarskog]

[posted and mailed, please reply in news]

Fardude (fa*****@bes.ci.portland.or.us) writes:

I had this problem in version 7 and dont remneber How I solved it!!
I have installed a local SQL Server (2000 aka version 8) on my
Worksation (W2K), I have picked NT authuntication.
Everything was fine untill I changed my password. Now SQL server can
not start because it fails to login. The old password is embedded
somwhere and I cant egt to it!!!
My workstation is on a network, so the password is my network
password.

Right-click My Computer, select Manage. In MMC find Services, and
in the list find the MSSQL Service. Right-click, select Properties
and there switch to the Log On tab. Change the password.

It's probably a good idea to have a special user for SQL Server that
can't log in interactively, so you don't have to change the password.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp