Set up Microsoft SQL server

For Microsoft SQL Mail to work correctly, Microsoft SQL Server must be configured to log on with a user account that has a valid MAPI mail profile. Perform these steps on the computer running the Microsoft SQL Server Service that will process the e-mail event.

1. On the Windows Start menu, point to Programs, point to Administrative Tools, and then click Component Services. The Component Services console appears.

   

2. In the console tree, click Services.

3. In the results pane, right-click on MSSQLServer and then click Properties. The Properties dialog box appears.

4. Click the General tab.

5. In the Startup Type list, click Automatic.

6. Click the Log On tab.

7. In the Log On As area, click This account. Enter the user account (domain or local) or click Browse to browse for a valid account. The user account you select needs to have a valid MAPI mail profile set up.

8. For information on determining the MAPI mail profile, see Determine the Microsoft outlook mail profile.

9. In the Password and Confirm Password boxes, enter the password for the user account.

10. Click OK.

11. Right-click the MSSQL Server service in the results pane, and then click Stop to stop the service.

12. After the MSSQL service stops, right-click the MSSQL Server service in the results pane, and then click Start to restart the service.

13. Close the Component Services console.

The next step in setting up an e-mail action is to determine the Microsoft Outlook profile. For more information, see Determine the Microsoft outlook mail profile.