Are you getting above error while trying to use windows authentication in your application to connect Sqlserver, if so you are missing 'NT AUTHORITY\NETWORK SERVICE' user in your database. you can follow below steps to solve this issue
1. Open Sqlserver->yourdatabase
2. Select security->user
3. Right click on user and select 'New User'
4. Create a user for 'NT AUTHORITY\NETWORK SERVICE'.
5. Select database role membership as db_owner
Now try your application, it should work fine.
HTH
No comments:
Post a Comment