Not able to link to it as the domain administrator

Asked By Jeffrey L Vogel 0 points N/A Posted on - 03/13/2013

I did load SQL Server Management Studio for just to search that I was not able to link to it as the domain administrator, regardless of being reasonably confident that the account had been settled the sysadmin role in SQL.

Some suggestion to fix it?

I am facing a problem regarding connecting the server I receive the error message:

Connect to Server

Cannot connect to localhost.

Additional information:

Login failed for user ‘ADTESTres’. (Microsoft SQL Server Error: 18456)

• Status: Open
• Question Views: 602
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Alice R Jones 0 points N/A #176231

Not able to link to it as the domain administrator

Trying to connect the SQL Server Authentication, you need to make sure that SQL Server is configured for Mixed Authentication mode. Please also verify the SQL server login exists and you have taken proper care while spelling the login information. You need to consider that you have logged into correct domain and verify that you are logged in correctly.

 

You can also try running the as administrator so as to avoid UAC error. Please check if it fades away.

 

Hope this helps!

About Alice R Jones

Questions
8

Answers
99

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 03/19/2013
• Question Category: MS SQL Server