Export (0) Print
Expand All

Configuring Mail Profiles

SQL Server 2000

  New Information - SQL Server 2000 SP3.

SQL Mail and SQL Agent Mail can use the same or different mail profile. If necessary, each mail profile can be configured within its own domain account.

Configuring a SQL Mail Profile

When configured, mail profiles are specific to the Microsoft® Windows NT® 4.0 or Windows® 2000 user domain account that is activated when a user logs on to Windows NT 4.0 or Windows 2000 successfully. SQL Mail must have a mail profile created in the same user domain account or context that is used to start an instance of Microsoft SQL Server™. When a mail stored procedure is executed, SQL Mail looks for the defined mail profile in the domain account that triggered it.

If you plan to use mail stored procedures you must:

  • Have a mail server that is extended MAPI-compliant.

  • Configure a mail profile for MSSQLServer to use to connect to your mail server.

    Security Note  For security reasons, you should ensure that users do not share the same temporary directory. Failure to change the default of the suppress_attach parameter to TRUE in the xp_readmail stored procedure creates attachments in the temporary directory. If two users share the same temporary directory and log on to the same computer, they will be able to view each other's attachments. You can determine where attachments are stored, and whether two users share the same temporary directory, by reviewing the attachments output variable. See xp_readmail for more details on suppressing attachments.

To configure a mail profile

Windows

To set up SQL Mail

Enterprise Manager

Configuring a SQL Agent Mail Profile

If you plan to send notifications to operators by e-mail or pager, you must:

  • Have a mail server that is extended MAPI-compliant.

  • Configure a mail profile for SQL Server Agent to use to connect to your mail server.

  • Have a mail server that is able to communicate with your pagers.

A mail profile is required by SQL Agent Mail to start a mail session and send notification by e-mail or pager. A SQL Server Agent mail session is started every time that the SQLServerAgent service is started. You can create the profile with a mail client, such as Microsoft Outlook®, that is installed locally on the SQL Server computer.

To configure a mail profile

Windows

To set up SQL Agent Mail

Enterprise Manager

Sharing a Profile with SQL Mail

SQL Mail and SQL Agent Mail sessions may be configured to use the same Windows NT 4.0 or Windows 2000 domain user account. When using the same domain account, SQL Mail and SQL Agent Mail can share the same mail profile using a common mailbox.

SQL Server uses two separate mail sessions:

  • The MSSQLServer service uses a mail session that is referred to as SQL Mail.

    SQL Server uses this mail session when database applications execute the xp_sendmail extended stored procedure to send a message or query result set to a recipient.

  • The SQL Agent Mail uses a mail session that is exclusive to SQL Server Agent activities.
Creating Separate Profiles

You can configure separate mailboxes for SQL Mail and SQL Agent Mail by creating separate mail profiles. There are two ways to accomplish this:

  • Use separate domain accounts for each service. This requires you to configure a mail profile for each user account.

  • Use the same domain account for each service and create multiple mail profiles.

For more information about setting up and configuring mail clients and mail profiles, see the Windows NT 4.0 and Windows 2000 documentation.

Show:
© 2014 Microsoft