August 24, 2003 at 8:17 am
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.
.
August 24, 2003 at 8:30 am
I have installed SMTP Service on the box yesterday. Do I need to configure anything before I use ?
.
August 24, 2003 at 8:37 am
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
K. Brian Kelley
@kbriankelley
August 24, 2003 at 8:38 am
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
K. Brian Kelley
@kbriankelley
August 25, 2003 at 10:50 pm
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