Microsoft login failed. Cannot open database requested by the login. sql server error 18456
This error is quite common and I have received it few times while I was working on a recent project.
Cannot open database requested by the login. The login failed.
Login failed for user ‘AAA’.
STEPS TO FOLLOW
1) Go to SQL Server - Security Logins and right click on account you want access(in my case its [AFFAQ/AFFAQ]and select Properties.
2) New Windows will be popup.. Select User Mapping and in User Mapping select desired Database especially the database for which this error message is displayed.
3) On the lower screen, check the role db_owner and Click OK.
In almost all such cases, this should fix your problem.
Here is video about MS SQL Server fails to retrive data
• Microsoft SQL Server Management Studi...
Facebook
/ howtoohow
You can also join us on twitter
/ howtohow1
Google +
https://plus.google.com/b/10778572094...
SUBSCRIBE Our Channel
/ @howtohow
Related Keywords
login failed for user sql server management studio error 18456, login failed for user sql server express, sql 2008, sql, login failed for user sql server 18456, login failed for user sql server 2016, login failed for user sql server, login failed for user sql server error 18456, login failed for user sql server 2016, login failed for user sql server, login failed for user sql server 2014, login failed for user sql server 2008, login failed for user sql server 2012, microsoft sql server (database management system), microsoft, microsoft sql server, login failed, error 18456, server authentication, sql server, login failed for user sql server, login failed for user sql server error 18456, login failed for user sql server 2008, login failed for user sql server c#, login failed for user sql server 2012, login failed for user sql server authentication, login failed for user sql server visual studio, login failed for user sql server management studio, windows, software, computer, database (file format genre), tutorial, hd, login failed for user sql server 2008 r2, login failed for user sql server error 18456, login failed for user \u0027sa\u0027. (microsoft sql server error 18456),22,30], login failed for user sql server 2014, login failed for user sql server 2008 r2, login, microsoft (business operation), sql server sa account, password, reset, source: mssqlserver id: 18456 (sql server ), 18456, login failed for user sa, login failed for user 'sa'. (microsoft sql server error 18456), mssqlserver id: 18456 (sql server ), error 18456 sql server, connection, error-code, how to, software (industry), sql (programming language), microsoft sql server (software), sql server express, icrosoft sql server (database management system),