The SMTP Server in xp_smtp_sendmail

[laurenq uantrell]

Just trying out xp_smtp_sendmai l for the first time.
I get the error:
Error: connecting to server smarthost
OK, so I don't have the server parameter for SMTP server set up
correctly.

I don't even know what an SMTP Server is! Is this an e-mail provider
that provides SMTP functionality, or an application I need to install?

[David Portas]

Re: The SMTP Server in xp_smtp_sendmai l

SMTP is a standard protocol for email. Most mail servers will support SMTP
so if you are on a corporate network you probably already have access to
ne - ask whoever manages your mail server.

If you don't already have one then you can set up IIS as an SMTP server.
This is not something I'm an expert on but here's a link about it:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/e4cf06f5-9a36-474b-ba78-3f287a2b88f2.mspx

One point about xp_smtp_sendmai l is that it requires the server to be setup
for sending mail without authentication. For that reason you probably won't
be able to use your ISP's email server.

--
David Portas
SQL Server MVP
--

[laurenq uantrell]

Re: The SMTP Server in xp_smtp_sendmai l

When I use a generic SMTP server like: SMTP.KnownProvi dorName.net I get
an error: ERROR: Sending Email

[laurenq uantrell]

Re: The SMTP Server in xp_smtp_sendmai l

Reding your link I am setting up the IIS/SMTP on my machine. I assume
this will not require authentication, but how eould this apply on a
client's server if I need to set it up that way?

[Trevor Best]

Re: The SMTP Server in xp_smtp_sendmai l

laurenq uantrell wrote:[color=blue]
> Reding your link I am setting up the IIS/SMTP on my machine. I assume
> this will not require authentication, but how eould this apply on a
> client's server if I need to set it up that way?
>[/color]

Your ISP's server shouldn't need authentication as it knows the range of
IP addresses allowed to relay from it, your IP should be in it's list :-)

On your client's network, the same would apply with their ISP's SMTP
server but as David says you could use their corporate mail server
assuming they have one and it's not a Hopeless Notes server.

I set up our main server for mail, using MAPI/Outlook/Exchange, this
means that the SQLSErver service must log in as an account other than
local system, you need to log onto windows using that account, load up
Outlook set up a profile and have SQL Server use that profile.