Microsoft KB Archive/870675

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

Article ID: 870675

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-





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.

