Unable to Login “Microsoft SQL Server, Error: 18456” error in SQL SERVER 2008 R2

Dear Friends,
Sometimes it happens when you did everything correct like Installation with mix mode, created new user assign credentials etc but still not able to login with the username and password credential.
You get “Unable to Login – Microsoft SQL Server Error: 18456”.
To resolve this error you need to do following steps
1) Login with Windows Authentication
2) Open server properties using right click
3) Go on security TAB
4) Check SQL Server And Windows Authentication mode Checkbox

Now you can login with user credentials.

Thanks & Best Regards,
Rajat Jaiswal

Advertisements

One thought on “Unable to Login “Microsoft SQL Server, Error: 18456” error in SQL SERVER 2008 R2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s