Cannot open database requested by the login. The login failed.
Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
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