Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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