Home / server / Questions / 313807
Accepted
rlb.usa
Asked: 2011-09-21 11:55:50 +0800 CST

Changed windows pwd; Can't connect to local sql anymore?

  • 772

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 ( https://stackoverflow.com/questions/5955470/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?

sql-server-2008 authentication

2 Answers

  1. Best Answer

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

    • 3

  2. 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

    • 2