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