sql-serversql-server-2012

sa user is locked out and login fails with Windows Authentication. Now what?


I am logged in to a Windows 7 computer as an admin. I am trying to connect to SQL Server 2012 on the same machine. The SA account is locked out. When I try Windows Authentication, the login fails.

How do I log in now? Is there an external tool to unlock the SA user? I used an external tool to change the SA password. I don't want to reinstall the software.


Solution

  • Read and follow the steps described in Connect to SQL Server When System Administrators Are Locked Out: