SMTP Configuration - Need Help

  • Hi All,

    I am about to use SMTP mail from SQL Server for the first time. Can you please let me know what do I need to do to configure SMTP on Windows 2000 Server. I am running SQL Server 2000 SP3 on Windows 2000 Server SP2.

    .

  • I have installed SMTP Service on the box yesterday. Do I need to configure anything before I use ?

    .

  • Find out from your system or mail administrators the name (or IP address) of your SMTP server.

    If you're going to use SQLMail, read through this Knowledge Base article, as it presents a reasonable coverage of how to setup SQLMail:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556

    If you're going to use SMTP without using SQLMail and you want to mail from inside SQL Server, do a search on support.microsoft.com for article # 312839. For whatever reason it's not currently available.

    Another solution is xpsmtp:

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

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • The SMTP service makes the box an SMTP server. However, this is probably not what you want. You probably just want to find out what the SMTP server is for your environment and then point to it.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • Brian,

    Could not get much info from the earlier article.

    Since this is the first time I am setting up SMTP mail sending out. If we are trying to send SMTP mail using vbscript, where would we specify SMTP Server Name or IPAddress?

    .

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

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