• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Cannot Synchronize Windows Login and SQL Login

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
gpfrank
Asked:
gpfrank
1 Solution
 
Einstine98Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now