How to set up SQL Mail with an Internet mail server by using Outlook 2002

Article translations Article translations
Article ID: 870675 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

This article discusses how to configure the SQL Mail feature in Microsoft SQL Server 2000. We recommend that you configure the SQL Mail feature in SQL Server 2000 (SQL Mail 2000) to send mail to a Microsoft Exchange Server or through a Microsoft Outlook 2000 Service Pack 3 (SP3) client. We do not recommend that you configure SQL Mail 2000 to send mail through a Post Office Protocol 3 (POP3) or Simple Mail Transfer Protocol (SMTP) account on a computer that has Microsoft Outlook 2002 installed. On a computer that has Outlook 2002 installed, you must start the Outlook 2002 client to receive e-mail though a POP3 or SMTP account.

INTRODUCTION

You can configure the SQL Mail feature in SQL Server 2000 (SQL Mail 2000) to send mail to an Exchange Server or through a Microsoft Outlook 2000 SP3 client. We do not recommend that you configure SQL Mail 2000 to send mail through a POP3 or SMTP account on a computer that has Microsoft Outlook 2002 installed.

MORE INFORMATION

In Outlook 2002, you must start the Outlook client so SQL Mail can send and can receive e-mail through an Internet mail server (POP3 or SMTP) by using Outlook 2002. You must start the Outlook client because the MAPI spooler runs in process. If you do not start Outlook 2002, messages remain in the Outbox until you start Outlook 2002. This behavior does not occur if you configure SQL Mail 2000 to send mail through an Exchange server or through a Outlook 2000 SP3 client. Because the MAPI spooler runs out of process in Outlook 2000 SP3, you do not have to start Outlook 2000 to send and to receive e-mail through SQL Mail 2000.

For additional information about how to download and install Outlook 2000 Service Pack 3 in Microsoft Office 2000 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:
326585 Description of the Office 2000 Service Pack 3 (S326585)
To configure SQL Mail 2000 to send e-mail, follow these steps:

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start, and then click Enterprise Manager.
  2. Expand Microsoft SQL Servers.
  3. Expand a server group, expand a server, and then expand Support Services.
  4. Right-click SQL Mail, and then click Properties.
  5. In the Profile name box, click the account you configured for SQL Mail 2000, and then click Test.
  6. Click OK.

REFERENCES

For additional information about how to configure SQL Mail, click the following article number to view the article in the Microsoft Knowledge Base:
263556 How to configure SQL Mail
For additional information about how to identify common SQL Mail issues, click the following article number to view the article in the Microsoft Knowledge Base:
315886 Common SQL Mail problems
For additional information about frequently asked SQL Mail questions, click the following article number to view the article in the Microsoft Knowledge Base:
311231 Frequently Asked Questions - SQL Server - SQL Mail
For additional information about using SQL Mail 2000 with Outlook 2000, click the following article number to view the article in the Microsoft Knowledge Base:
281293 FIX: SQL Mail 2000 needs Microsoft Outlook 2000 client
For additional information about using SQL Mail extended stored procedures, click the following article number to view the article in the Microsoft Knowledge Base:
320407 FIX: SQLMail extended stored procedures may fail with an access violation on SQL Server 2000 Service Pack 2 when SQL Server is run as a Windows NT service
For additional information about using SQL Mail in a virtual SQL Server cluster, click the following article number to view the article in the Microsoft Knowledge Base:
298723 BUG: SQL Mail not fully supported for use in conjunction with cluster virtual SQL servers

Properties

Article ID: 870675 - Last Review: April 7, 2006 - Revision: 2.3
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbhowto KB870675

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com