SQL Server Configuration for IIS (Anonymous and Windows authentication)

For SQL Server configuration with Anonymous Authentication and SQL Server with Windows Authentication, follow this article.

If in IIS, Authentication mode is set to Anonymous Authentication for Innowera ESharethen 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 field 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. The user ‘NT AUTHORITY\IUSR’ is displayed. Provide the access rights by selecting the checkboxes under the Database role membership for: section as shown in the following screenshot, and then select OK.

   

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