up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

migrated from stackoverflow.com Sep 21 '11 at 8:08

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

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.

link|improve this answer
feedback
up vote 2 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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