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:
What should I do next?
Best Answer
check what user account SQL Server is running as. If you set it to e.g. LocalSystem it should work.