Thursday, October 23, 2014

Login failed for user 'NT AUTHORITY\NETWORK SERVICE' [Solved]

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. Set server roles "Public" and "Sysadmin"
  8. Click OK
    Here's a screenshot of the above: 

No comments:

Post a Comment