Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Sep 21 '11 at 8:08

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

add comment

2 Answers

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
add comment

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.

See http://msdn.microsoft.com/en-us/library/ms143504.aspx

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
add comment

Your Answer

 
discard

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.