Help and Support
 

powered byLive Search

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

Article ID:870675
Last Review:April 7, 2006
Revision:2.3

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.

Back to the top

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.

Back to the top

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 (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.
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.

Back to the top

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

Back to the top


APPLIES TO
Microsoft SQL Server 2000 Standard Edition

Back to the top

Keywords: 
kbhowto KB870675

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.