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. SQL Mail can be enabled by opening the Properties dialog box from the SQL Mail node of Management Studio, by using the Surface Area Configuration facet of Policy-Based Management, or by using the sp_configure stored procedure.
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
On the Microsoft Exchange server, set up a mailbox for the user that SQL Server runs as. This account must be a domain account.
Install an Exchange client on the computer that runs SQL Server.
Log on to the computer that runs SQL Server. Use the name and password used to start SQL Server.
The account used to start SQL Server must be a domain account.
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.
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.
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.