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.

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the Reporting Server. In the Database Engine Configuration I just checked Windows Authentication Mode and specified a Security Group I created on the AD as the SQL Server Administrators.

I log in to the SQL Server with an account that is Domain Admin and a member of the SQL Server Adminsitrators group. When I open SSMS I can login to the Reporting Services using Windows credentials, but are not able to contact the Database Engine. Login failed for user 'MYDOM\myadminuser' Reason: Could not fund a login matching the name provided. [CLIENT: ]

  1. I see a lot of tips saying: "Use mixed mode instead of Windows authentication mode". Where can I change that if I cannot access the Database Engine with SSMS.
  2. Followup: I want to authenticate only users known in the AD. Why would I need mixed mode?
share|improve this question
    
If you are unable to login to the database engine, you will need to rip it out and reinstall using Mixed auth. Mixed auth is good for initial testing and setup in case you are unable to login with win auth. –  DanBig Oct 16 '13 at 14:40
    
Come on, there's got to be a way to reconfigure this. And, as said, I really don't want mixed mode! So why should I test it? –  Martijn Burger Oct 16 '13 at 14:48
    
I've never seen a way to get into an instance you are basically locked out of besides uninstalling. –  DanBig Oct 16 '13 at 14:54
    
You can try this: msdn.microsoft.com/en-us/library/dd207004.aspx But if you are locked out of the engine, for whatever reason, there usually isn't a way to get back in. –  DanBig Oct 16 '13 at 15:25
1  
If your account is locked, you are locked out. What am I missing here? –  DanBig Oct 16 '13 at 16:21
show 2 more comments

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.