Not able to link to it as the domain administrator

Asked By 0 points N/A Posted on -
qa-featured

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:

Login failed for user “…./….”

Connect to Server

Cannot connect to localhost.

Additional information:

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

SHARE
Answered By 0 points N/A #176231

Not able to link to it as the domain administrator

qa-featured

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!

Login/Register to Answer

Related Questions