SQL Mail Configuration - Win 2003 and SQL 2000

Question

Post reply

SQL Mail Configuration - Win 2003 and SQL 2000

phil.curtis

SSC Enthusiast

Points: 146
More actions
January 26, 2010 at 11:43 am

#96798

I need to configure SQL Mail on a Windows 2003 server running SQL Server 2000. I don't want to install Outlook to do this. I've read about xp_smtp_sendmail from sqldev.net. However, it looks like the website is no longer functioning.
Any advice on here to go for a solution?
Thanks,
Phil Curtis

Viewing 8 posts - 1 through 7 (of 7 total)

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

Shriji SSCommitted Points: 1881 More actions · Answer 1

Do you have an option to install Outlook client only?

Navnish

phil.curtis SSC Enthusiast Points: 146 More actions · Answer 2

phil.curtis

SSC Enthusiast

Points: 146

January 26, 2010 at 1:23 pm

#1108914

No.

Shriji SSCommitted Points: 1881 More actions · Answer 3

try this one....

http://support.microsoft.com/kb/312839

Navnish

Shriji SSCommitted Points: 1881 More actions · Answer 4

Did you try to use gmail SMTP?

this thread may be helpful...

http://www.sqlservercentral.com/Forums/Topic690626-146-1.aspx

Navnish

Jeffrey Williams SSC Guru Points: 90304 More actions · Answer 5

phil.curtis (1/26/2010)
I need to configure SQL Mail on a Windows 2003 server running SQL Server 2000. I don't want to install Outlook to do this. I've read about xp_smtp_sendmail from sqldev.net. However, it looks like the website is no longer functioning.
Any advice on here to go for a solution?
Thanks,
Phil Curtis

SQL Mail on SQL Server 2000 requires a MAPI client be installed on the server. That does not mean it has to be Outlook, but that is the recommend client for setting up SQL Mail.

If, however - all you want to be able to do is send mail from a procedure here is a document that explains one way this can be done: http://www.sqlteam.com/article/sending-smtp-mail-using-a-stored-procedure

Or, you can upgrade to SQL Server 2005 and use Database Mail instead.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

phil.curtis SSC Enthusiast Points: 146 More actions · Answer 6

My goal is to use the mail interface to email notifications on DTS job failures.

Jeffrey Williams SSC Guru Points: 90304 More actions · Answer 7

phil.curtis (1/26/2010)
My goal is to use the mail interface to email notifications on DTS job failures.

I'm sorry - but what mail interface? You cannot use SQL Mail without installing a MAPI client - period.

If you are using DTS, you can implement an smtp task in DTS for notification. Google for DTS and SMTP task and you should be able to find it.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs