Set Windows Integration Authentication Mode

2014/07/17 17:37

1. Set "Windows Integration Authentication" Mode

The method to set "Windows Integration Authentication" mode in Windows 2003 and Windows 2008 environment is different.


2. Setting Method in Windows 2003

If you have chosen the "Windows Integration Authentication" mode for AAMail database (Figure 1-1), something will be wrong when you directly login Webmail, then you need to add the "anonymous access user name" to the SQL Server login list.

Database Settings

Figure 1-1


How to Find the Anonymous Access User Name?

Open IIS Manager, on the "Web Sites" directory tree, right click "Default Web Site" and select "Properties". Then click the "Directory Security" tab, and then click the "Edit" button. It will pop up the "Authentication Methods" dialog box, and you can find the "anonymous access user name: IUSR_WIN2003-ENT-32" (Figure 1-2).

Authentication Methods

Figure 1-2


How to Add the Anonymous Access User Name to the SQL Server Login List?

1) Open the SQL Server Management Studio Express.

2) Expand the "Security" directory => Right click "Logins", and select "New Login..." (Figure 1-3).

New Login

Figure 1-3

3) In the pop up "SQL Server Login Properties - New Login" dialog box, select the "Windows Authentication" radio button, and then select the "Grant access" radio button, and click the "..." button (Figure 1-4).

SQL Server Login Properties

Figure 1-4

4) Select the "anonymous login account (IUSR_1-1F5B7A0D14414)", and click the "Add" button, then click the "OK" button (Figure 1-5).

SQL Server Login Properties

Figure 1-5

5) Click the "Database Access" tab, and select "sqlmail", "public", "aa_owner" check boxes. Then click the "OK" button (Figure 1-6).

Database Access

Figure 1-6


3. Setting Method in Windows 2008

Set IIS

1) Open IIS, and click the "Application Pools", then right click "DefaultAppPool", and select "Advanced Settings..." (Figure 1-7).

Application Pools

Figure 1-7

2) In the pop up "Advanced Settings" dialog box, click the "..." button on the right of "Identity", and then select the "NetworkService", and click the "OK" button (Figure 1-8).

Advanced Settings

Figure 1-8

Set the Database

1) Open the SQL Server Management Studio Express.

2) Expand the "Security" directory => Right click "Logins", and select "New Login..." (Figure 1-9).

New Login

Figure 1-9

3) In the pop up "SQL Server Login Properties - New Login" dialog box, select the "Windows Authentication" radio button, and then select the "Grant access" radio button, and click the "..." button (Figure 1-10).

SQL Server Login Properties

Figure 1-10

4) Select the "anonymous login account (IUSR_WIN2003-ENT-32)", and click the "Add" button, then click the "OK" button (Figure 1-11).

SQL Server Login Properties

Figure 1-11

5) Click the "Database Access" tab, and select "sqlmail", "public", "aa_owner" check boxes. Then click the "OK" button (Figure 1-12).

Database Access

Figure 1-12



Related: