Monday 11 June 2012

SQL SERVER : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.


Cannot open database requested by the login. The login failed.
Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.


This is Common error which i found a solution

How to Fix??


1. Go to SQL Server >> Security >> Logins and right click on NT 
AUTHORITY\NETWORK SERVICE and select Properties



2. In newly opened screen of Login Properties, go to the “User 
Mapping” tab. Then, on the “User Mapping” tab, select the desired 
database – especially the database for which this error message is 
displayed. On the lower screen, check the role db_owner. Click OK.




No comments:

Post a Comment

Please Leave Your Comment here

You Might also like this

Related Posts Plugin for WordPress, Blogger...