Determine the Microsoft outlook mail profile

To properly set up the Microsoft SQL Server e-mail configuration, you need to know the name of the MAPI mail profile for the MSSQL Server service logon account. You must determine the MAPI profile name on the computer running MSSQL Server.

To determine the MAPI profile name

1. In Control Panel, double-click Mail.

2. Click Show Profiles.

3. Determine the MAPI mail profile.

   The mail profile is commonly set to "MS Exchange Settings" so that the use the user's profile on an Exchange Server is used.

4. Click OK.

   For more information on configuring user accounts for the Exchange Client, see your Microsoft documentation.

The next step in setting up an e-mail action is to configuring SQL mail in SQL Server Management Studio. For more information, see Set up SQL mail in SQL management studio.