N/APosted 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.
Login failed for user ‘ADTESTres’. (Microsoft SQL Server Error: 18456)
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!