Log-in Error NT_AUTHORITYIUSR

The Problem mostly seen, in my network, the workstations where I had SQL Server 2008 standalone (180 days trial) and later I used SQL Server Express edition. Mostly I created external database while documenting SQL language tutorials, and wanted to use the same in Visual Studio 2008

OR

OR

The Above Error comes from the Permission status

Now if you look at the IUSER in the application mm.AdoConnected2 and compare with mm.AdoConnected1, you will notice that

 

Let us assume that I am an admin, I know what IUSR is !

Now empowered Full control to IUSR

Add the following line (appropriate user and password , as shown as a demo below); in Web.config file

 <system.web><identity impersonate="true" userName="Administrator" password="Manas6"/>  </system.web>

Any mistake  will be posted like this

Right Name and password in

Simple One Line Fix

Walla!

 

Note I did not change any profiles as shown in the following display.

<identity impersonate="true" userName="Administrator" password="Manas6"/>

 

Example : NTAUTHORITY\IUSR : The login failed

Problem

Fix

<identity impersonate="true" userName="Administrator" password="Manas6"/>

Confirmation