Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Yesterday I had to change my windows logon password.

Today, when I try to connect to my local instance of Sql Server 2008 R2 through Management Studio, it gives me an error message. After reading this ( Cannot connect anymore to local SQL Server 2008 database ), I tried to start up the SQL Server process, but it gives me a logon failure:

enter image description here

What should I do next?

share|improve this question

migrated from Sep 21 '11 at 8:08

This question came from our site for professional and enthusiast programmers.

up vote 3 down vote accepted

check what user account SQL Server is running as. If you set it to e.g. LocalSystem it should work.

share|improve this answer

In Sql Server Configuration Manager check the account that the Sql services are running as. If you are running it as your account. Update the password or create a new low privileged account for running SQL (best practice). The Localsystem account will work but is not good practice.


share|improve this answer
no but it does'n matter much on a local dev machine – Rickard Sep 20 '11 at 20:27
@Rickard True is most cases. However some functions such as backups and agent tasks may work differently/unexpectedly in production with different permissions. – Bernie White Sep 20 '11 at 20:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.