troubleshooting Question

SQL server account lost password

Avatar of vanroybel
vanroybel asked on
Active DirectoryMicrosoft SQL Server 2008Windows Server 2008
15 Comments2 Solutions346 ViewsLast Modified:

I had a problem this morning arriving at work, our SQL server was down. I checked the service and the service was stopped. Then I try to restart it and it doesn't (it gives a 1069 error). After looking a bit it seems it's a logon problem. My configured SQL user cannot log into sql server anymore. So i simply put another user in its place and it works for now.
I got my quick fix with this but I still got a few problem with it. I would like to reconfigure the user I had before. Problem is this server was installed by other people. I tried finding the user in the active directory users but I couldn't find it.

Is it possible this user is hidden some way? Or maybe it's configured as a system user so that it doesn't show where my "normal" users are? I need to change the password for that user so I can log in with it again. The active directory is on the primary domain controller which is a small business server 2003.

Thanks for your help.
Pushpakumara Mahagamage

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros