469,280 Members | 1,835 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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
Jul 20 '05 #1
1 1546
[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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Adam Smith | last post: by
reply views Thread by moko | last post: by
9 posts views Thread by webrod | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.