SQL Server Configuration for IIS (Anonymous and Windows Authentication)

If in IIS, Authentication mode is set to Anonymous Authentication for Web and Mobile Server then the user needs to create login for the ‘NT AUTHORITY/IUSR’ user and, also provide the access rights to ‘NT AUTHORITY/IUSR’ user for database configured.

To create login for the ‘NT AUTHORITY/IUSR’ user,

1. Log into Microsoft SQL Server Management Studio Express. Right-click on Logins folder > New Login.

   

2. In the Login- New window, Windows authentication is selected by default. Select Search.

   

   

3. Enter IUSR and select Check Names. Once the name is selected, select OK.
4. The Login name displays ‘NT AUTHORITY\IUSR’. Choose the default database for which the user needs to be given permission and select OK.

   

5. Select User Mapping and select the check box for the database selected. ‘NT AUTHORITY\IUSR’ is displayed. Provide the access rights by selecting the checkboxes under the ‘Database role membership for:’ as shown in the following screenshot, and then select OK.

   

6. The NT AUTHORITY\IUSR gets displayed under Logins as seen in the following screenshot.