By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,627 Members | 1,870 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,627 IT Pros & Developers. It's quick & easy.

The SMTP Server in xp_smtp_sendmail

P: n/a
Just trying out xp_smtp_sendmail 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?

Sep 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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/pro...87a2b88f2.mspx

One point about xp_smtp_sendmail 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
--
Sep 23 '05 #2

P: n/a
When I use a generic SMTP server like: SMTP.KnownProvidorName.net I get
an error: ERROR: Sending Email

Sep 23 '05 #3

P: n/a
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?

Sep 23 '05 #4

P: n/a
laurenq uantrell wrote:
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?


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.
Sep 24 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.