How to set up SQL Mail with an Internet mail server by using Outlook 2002
SUMMARYThis 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. INTRODUCTIONYou
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 INFORMATIONIn 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 (http://support.microsoft.com/kb/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.
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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/298723/)
BUG: SQL Mail not fully supported
for use in conjunction with cluster virtual SQL servers
| Article Translations
|

Back to the top
