July 17, 2001 at 8:37 am
Ok... New thread. I've got a customer that wants his sql servers to send email notifications but doesn't want to install exchnage. We have a relay mail server that we could open up smtp on and give them an account for mail. If I remember correctly you can setup sql mail to use smtp and pop3 but you still have to have a MAPI copliant client yes?
July 17, 2001 at 10:19 am
If you're running win2k and have the smtp service running on the same machine, you can use the CDO.message object from within a stored proc or dts activex script to send the mail. No MAPI client needed.
July 17, 2001 at 10:42 am
SQLMail replies a MAPI profile belonging to the same account as what the MSSQLServer service is running under, yes.
With Win2K, there's also CDO for Windows 2000, which is am improvement over CDO 1.2.1. CDO for Win2K allows you to specify a relay server other than the local machine according to the code samples on the MSDN Library site (URL may wrap):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_messaging.asp
Look under Programming Tasks >> Configuring the Message Object.
K. Brian Kelley
K. Brian Kelley
@kbriankelley
July 17, 2001 at 11:16 am
Sorry I should have given more info. This cluster is a nt4sp5 cluster with sql 7.0 on it. I know 7.0 wasn't as strict about smtp as 2000.
Wes
July 17, 2001 at 11:24 am
Sounds like what you need to do is create a MAPI profile that connects to the SMTP Server via POP3. Enclosed is the Q article from TechNet which talks about configuring SQLMail:
http://support.microsoft.com/support/kb/articles/Q263/5/56.ASP
K. Brian Kelley
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply