sending email alerts from Sql Server

[helpful sql]

Hi,
I would like to send email alerts from Sql Server when a Sql Server job
fails. When I try to send a test alert from Sql Server, it gives me an error
saying something like "Outlook is not set as the deault client". I don't
know how to fix this. Can anyone please help?

Thanks in advance.

 

[Groove]

I tried this months ago and to abandon the idea due to off site email server
issues.

I vaguely remember something along the lines of Outlook 2000 or higher must
be installed and you MUST have an MS Exchange Server account to send from.
Some said the Exchange account wasn't required and some said it was. I
think ultimately, I found out it was required.....

 

[Aaron Bertrand [SQL Server MVP]]

http://www.aspfaq.com/2403

 

[Maninder]

http://www.sqldev.net/xp/xpsmtp.htm
Try using this. I use this all the time.
There is a well known Best Practice on PROD Servers of not using Office
componenets on PRODUCTION BOXES beacuse of Security Factors.
Make Life Easier for you.. use something that already there.... and
easier to use.

 

[Aaron Bertrand [SQL Server MVP]]

I tried this months ago and to abandon the idea due to off site email

server issues.

Any Windows or Unix server within your network (including the SQL Server box
itself) can be configured to accept SMTP traffic and relay it (and this can
be made safe from abuse simply by being inside your network and having a
half-competent noc person employed or contracted).

I vaguely remember something along the lines of Outlook 2000 or higher
must be installed and you MUST have an MS Exchange Server account to send
from.

This is only for SQL Mail. There are plenty of other alternatives for
sending mail from SQL Server (see the link I posted earlier).

A

 

[Greg D. Moore \(Strider\)]

I tried this months ago and to abandon the idea due to off site email server
issues.

I vaguely remember something along the lines of Outlook 2000 or higher must
be installed and you MUST have an MS Exchange Server account to send from.
Some said the Exchange account wasn't required and some said it was. I
think ultimately, I found out it was required.....

It is not required.

However, my experience has found that you should install the SMTP server
that comes with IIS on the same physical box as SQL Server.

Set up your outlook profile (which IS absolutely required with SQL 2000) to
send to that local SMTP server. This will eliminate almost all your
problems. This works great for sending from SQL Server. I tend to not send
TO SQL Server.

Remember to setup the Outlook profile from the same account SQL Server and
Agent are running from.

 

[Aaron Bertrand [SQL Server MVP]]

Set up your outlook profile (which IS absolutely required with SQL 2000)

to
send to that local SMTP server.

Why is Outlook "absolutely required"? I use Gert's xp on multiple servers,
and none of them have Outlook installed.

 

[Aaron Bertrand [SQL Server MVP]]

Set up your outlook profile (which IS absolutely required with SQL 2000)

to
send to that local SMTP server.

Why is Outlook "absolutely required"? I use Gert's xp on multiple servers,
and none of them have Outlook installed.

 

[Greg D. Moore \(Strider\)]

Why is Outlook "absolutely required"? I use Gert's xp on multiple servers,
and none of them have Outlook installed.

If you're using the native xp_sendmail or the having SQL Agent send
success/failure emails(which is what I believe the original poster was
asking about) you need a MAPI compliant mail client. Outlook is the
"easiest".

If you're using other XPs, obviously the requirements are different.