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

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[posted and mailed, please reply in news]

Fardude (fardadk@.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, sommar@.algonet.se

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