SQL Mail

SQL Server 6.5 provides the following enhancements to SQL Mail:

• You can start and stop SQL Mail, and you can assign a mail login name and a password to SQL Mail from SQL Enterprise Manager.

    To start and stop SQL Mail from SQL Enterprise Manager

1. In the Server Manager window, expand the tree for the server, and click the right mouse button on that server's SQL Mail icon.
2. From the shortcut menu, choose Start or Stop.

    To assign a mail login name and a password to SQL Mail from SQL Enterprise Manager

1. In the Server Manager window, click the right mouse button on the SQL Mail icon.
2. From the shortcut menu, choose Configure.

   The SQL Mail Configuration dialog box appears.

3. Complete the dialog box.

   On servers where Microsoft Exchange has been installed, this dialog box will ask for a profile name.

   For more information about setting up a SQL Mail Client, see the Microsoft SQL Server Administrator's Companion.

• Enhancement to xp_sendmail makes it easier to use within triggers. For more information, see What's New for Transact-SQL, later in this document.
• Enhancement to xp_readmail now supports an additional output parameter that returns the mail message originator's mail address.
• SQL Mail is compatible with Microsoft® Exchange.

    To set up SQL Mail to work with Microsoft Exchange

1. At the Microsoft Exchange server, set up a mailbox for the user account that will be used by the MSSQLServer service. This account must be a domain account that adheres to the requirements listed under Platform Support in "What's New for Setup," earlier in this document. For example,

2. At the SQL Server machine, log on to Windows NT using the same user account that will be used by the MSSQLServer service ("DOMAIN1\SQLServerAccount" in the example above).
3. Install the Microsoft Exchange Client on the SQL Server machine.
4. Start the Microsoft Exchange Client and use the Exchange Setup Wizard to configure the client to connect to Microsoft Exchange Server. After setup is complete, verify that you can send and receive mail interactively.

   Note You cannot use the Microsoft Exchange Client to connect SQL Server to Microsoft Mail post offices.

5. Start the Microsoft Exchange Services application (also called the Mail and Fax application in Control Panel). Choose the Show Profiles button to find the name of the profile that the Exchange Setup Wizard has created (for example, SQL Server).

   Note Before you configure Microsoft Exchange Server, read the SQL Mail and Microsoft Exchange Server Configuration Requirements section.

6. From Control Panel, open the Services application and configure the MSSQLServer service to run under the same Windows NT user account that Microsoft Exchange is set to use. Start or restart the MSSQLServer service.
7. In SQL Enterprise Manager, select a server and from the Server menu, choose SQL Mail/Configure or right-click the SQL Mail icon below the selected server and choose Configure. Type the profile name you found in step 5. You do not need to provide a password for Microsoft Exchange; it uses the account and password configured for the MSSQLServer service.
8. In SQL Enterprise Manager, from the Server menu, choose SQL Mail/Start or right-click the SQL Mail icon and choose Start. The SQL Mail icon will become green if SQL Mail has started successfully.

   For more information on setting up Microsoft Exchange, see the Microsoft Exchange Server Installation Guide.