Set SMTP for SQL 2000

Question

Set SMTP for SQL 2000

dom-782167

SSC Rookie

Points: 37
More actions
July 7, 2008 at 5:14 pm

#184301

The SQL 2000 server is running on a network that is not connected to the internet, but does have a connection to an exchange server that we can send mail through. So that we can send alert emails it it necessary to set an SMTP address in SQL to the exchange server address. I cannot find in SQL 2000 where to include the SMTP address?
Dom

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

First, please post in the appropriate forum to get an answer.

Next, you send to an email address, but set the Exchange server as the MAPI server for your Outlook Profile. Search SQLMail to find setup instructions.

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 2

Or, forget about MAPI and use Gert's xp_smtp instead.

http://sqldev.net/xp/xpsmtp.htm

Used it for years while on 2000 - never had any problems with it..

/Kenneth

J-440512 SSCertifiable Points: 6285 More actions · Answer 3

Check out this link [font="Courier New"]http://www.sqlservercentral.com/Forums/Topic527864-110-1.aspx[/font]

This allows you to send (NOT receive) e-mail notifications using SMTP without having to have OUTLOOK running on the host machine for the SQL Server 2K.