How to unlock sa user in SQL Server 2012 if Windows Authentication doesn't work?
Posted
by
Tony_Henrich
on Server Fault
See other posts from Server Fault
or by Tony_Henrich
Published on 2012-11-23T21:41:20Z
Indexed on
2012/11/23
23:05 UTC
Read the original article
Hit count: 167
sql-server
|sql-server-2012
I am logged in as an admin on the computer. For some reason I can't log into SQL Server 2012 which is running on the same machine. The SA user is locked out. SQL Server was installed when I was logged in into my company's domain. I am not logged into the domain when I try to log in to sql server. I don't know if this matters st all.
However I expect to log using Windows authentication if I am in the administrator group?
© Server Fault or respective owner