Solved

Cannot Synchronize Windows Login and SQL Login

Posted on 2006-07-13
1
200 Views
Last Modified: 2006-11-18
Greetings to all, Recently I have had the need to change the domain admin password that I use to login to my W2K Servers. This was done because of an employee leaving.  When I change the admin password on the server that
is hosting the SQL Server, I cannot get into SQL and sych the password with windows. And SQL then stops working and can't be backed up, etc. The only thing I can do is to put the admin domain password back to what is used to be. This gets everything working again. I have tried all the online fixes but none of them will work. What am I missing? There is an old SQL database residing on another server too. We don't use it anymore. Could that be part of the problem? I am not experienced in SQL 2000 at all. I am placing a value of 500 points on this as I need this to be resolved asap. I fear that the fired employee is logging into our server, and therefore I need to reset the admin password]s right away. Thank you for your help in advance. You guys rock!
0
Comment
Question by:gpfrank
1 Comment
 
LVL 12

Accepted Solution

by:
Einstine98 earned 500 total points
ID: 17103022
maybe your SQL serer service is running under the Admin account? check that out and if it is the case, then change the service to run under another account...

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question