Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

by

I was experiencing a similar error message that I noticed in the Windows Event Viewer that read:

Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. Reason: Failed to open the explicitly specified database. [CLIENT: local machine]

The solution that resolved my problem was:

  1. Login to SqlExpress via SQL Server Management Studio
  2. Go to the “Security” directory of the database
  3. Right-click the Users directory
  4. Select “New User…”
  5. Add ‘NT AUTHORITY\NETWORK SERVICE’ as a new user
  6. In the Data Role Membership area, select db_owner
  7. Click OK

Here’s a screenshot of the above:
Screenshot of adding new user Network Service as db_owner to SqlExpress

More Related Contents:

  1. Avoid web.config inheritance in child web application using inheritInChildApplications
  2. How to increase request timeout in IIS?
  3. Setting up connection string in ASP.NET to SQL SERVER
  4. How to set the Default Page in ASP.NET?
  5. Difference between and ?
  6. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  7. HTTP Error 500.19 – Internal Server Error
  8. Escape quote in web.config connection string
  9. Nested ASP.NET ‘application’ within IIS inheriting parent config values?
  10. The configuration section ‘system.web.extensions’ cannot be read because it is missing a section declaration
  11. Unrecognized attribute ‘targetFramework’. Note that attribute names are case-sensitive
  12. What is the difference between ‘classic’ and ‘integrated’ pipeline mode in IIS7?
  13. Meaning
  14. Asp.NET Web API – 405 – HTTP verb used to access this page is not allowed – how to set handler mappings
  15. Cannot read configuration file due to insufficient permissions
  16. How to set the maxAllowedContentLength to 500MB while running on IIS7?
  17. Read connection string from web.config
  18. System.Security.SecurityException when writing to Event Log
  19. Request is not available in this context
  20. Error – SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
  21. Unable to start debugging on the web server. Could not start ASP.NET debugging VS 2010, II7, Win 7 x64
  22. IIS URL Rewrite and Web.config
  23. Remove HTML or ASPX Extension
  24. Setting up redirect in web.config file
  25. Forms Authentication Ignoring Default Document
  26. How to set up subdomains on IIS 7
  27. How can I get gzip compression in IIS7 working?
  28. Allow anonymous authentication for a single folder in web.config?
  29. User ASP.NET runs under
  30. URL Routing, Image Handler & “A potentially dangerous Request.Path value”

Leave a Comment