Cannot Synchronize Windows Login and SQL Login
Posted on 2006-07-13
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!