Microsoft SQL Server Error: 18456 occur

Asked By James C Montes 50 points N/A Posted on - 05/25/2014

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)

• Status: Open
• Question Views: 845
• Answer Count: 1
• Vote Up 3 Vote Down

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

Answered By 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.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 05/25/2014
• Question Category: MS SQL Server