SQL SERVER - Login Failed for "NT-AUTHORITY\IUSER"

When your connection string has the words "Integrated Security=SSPI" and you try to access the database, you will get this error

Login Failed for "NT-AUTHORITY\IUSER".

Below are the steps to resolve the error:

• Open your Microsoft SQL Server Management Studio
• Connect to your SQL Server instance
• Expand the Security Node
• Right Click > Add New User

In the add User Dialog Box, select IUSER and click "Find Now"
It will select NT-AUTHORITY\IUSER.
Click Add button.
Map appropriate database - access rights.
Thats it...enjoy :)

/Alpesh

If you find the above link useful, let us know your feedback, it will help us to improve our posting(s). or You can send your feedback linkOblast.
Report Broken Link