Solved

Cannot Synchronize Windows Login and SQL Login

Posted on 2006-07-13
1
199 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now