Microsoft SQL Server Error: 18456 occur

Asked By 50 points N/A Posted on -

Hi all,

When I try to connect to the SQL server 2008 R2, I ended up with an error message. The error says it cannot connect to local host and it says the login failed. However, I have the authority to access the server. In that case, why I got this error? Please help me to resolve this error and to find solutions. Thanks a lot.


Connect to Server

Cannot connect to localhost.

Additional information:

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

Answered By 105 points N/A #167878

Microsoft SQL Server Error: 18456 occur


This error means that the SQL server address you typed was correct and your user ID and password was received by the server successfully but couldn’t proceed to your request. There are several causes for this error.

First of all, make sure that the UserID is correct. The SQL Server is unable to find the specified user ID on the server as the ID isn’t granted to access on the server or typing mistake might also take place.

Check your password. It is also important because wrong password might also create such errors.

There is also possibility that the UserID is disabled on the server. Check that the password hasn’t expired. If you’re utilizing SSMS, you might have to run as different user to use the option.

Login/Register to Answer

Related Questions