SQL Server Configuration for IIS with Anonymous Authentication

This section explains you the SQL Server configuration for Internet Information Services (IIS) with Anonymous authentication.

Note: During installation IUSR user is created automatically if Windows Authentication is selected. If creation of IUSR user fails, perform the following steps to create the user manually.

In IIS, if the authentication mode is set to anonymous for Innowera Control Panel, then the user needs to create a login for NT AUTHORITY/IUSR user and also provide the access rights to NT AUTHORITY/IUSR user for the configured database.

To create log in for NT AUTHORITY/IUSR user,

1. Go to Microsoft SQL Server Management Studio Express> Security. Right-click Logins and select New Login. The Login-New page appears.
2. In the Login name section, select Windows authentication and select Search. The Select User or Group dialog appears.

   

3. Enter Internet User (IUSR) name and select Check Names. The list of IUSR names appears.
4. Select the IUSR name and select Ok. The selected user appears in the Login name box on the Login - New page.

   

5. In Default database, select the database for which you want to provide access to the user and select OK.

   

6. In User Mapping > User mapped to the login, select the database mapped to the user that you had created.
7. In Database role membership for:<database_name>, select the database roles, and select OK. The new user login appears on the Summary page.