mail and sql 7.0 running through a relay server.

  • Wesley Brown

    SSChampion

    Points: 12035

    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?

    http://www.sqlserverio.com
    http://www.cactuss.org
    http://www.salssa.org

  • jwiner

    SSCrazy

    Points: 2241

    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.

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    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

    bkelley@agfirst.com

    K. Brian Kelley
    @kbriankelley

  • Wesley Brown

    SSChampion

    Points: 12035

    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

    http://www.sqlserverio.com
    http://www.cactuss.org
    http://www.salssa.org

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    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

    bkelley@agfirst.com

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 5 (of 5 total)

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