How to: Configure Mail Profiles for Use by SQL Mail (Windows)

This topic describes how to configure a mail profile for SQL Mail. Before you can use SQL Mail, you must also enable SQL Mail using the Surface Area Configuration tool.

Note

SQL Mail will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use the feature.

To configure mail profiles to use to use for SQL Mail

  1. On the Microsoft Exchange server, set up a mailbox for the user that SQL Server runs as. This account must be a domain account.

  2. Install an Exchange client on the computer that runs SQL Server. For Microsoft SQL Server 2005, supported Microsoft Exchange clients are Microsoft Outlook XP and Outlook 2003.

  3. Log on to the computer that runs SQL Server. Use the name and password used to start SQL Server.

    Note

    The account used to start SQL Server must be a domain account.

  4. Start the Exchange client and configure the client to connect to the Exchange server. To do this, you provide the name of the Exchange server and the name of the mailbox created in step 1.

  5. In Control Panel, double-click the Mail icon. Click Show Profiles to display the list of profiles on the computer. Find the name of the profile created in Step 4. If the name of the profile is longer than 32 characters, or contains non-alphabetic characters such as pound signs or hyphens, change the name of the profile to be less than 32 characters and contain only alphabetic characters and spaces.

  6. Configure SQL Mail to use the profile name specified in step 5. For more information on how to configure SQL Mail to use an existing profile, see How to: Set Up SQL Mail (SQL Server Management Studio).

    Send e-mail to yourself using master.dbo.xp_sendmail to ensure that the mail client, mail profile, and e-mail provider are working properly.

See Also

Concepts

Database Mail

Other Resources

Surface Area Configuration
xp_sendmail (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance