Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

You'll have to log in using the same user that you installed SQL Server with. Beginning with SQL 08, the administrators group, by default no longer has access. You have to give access to the administrators group explicitly.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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