Configuring SQL Mail without Outlook

Hi,
I have a client that wants to take advantage of SQL Mail (particularly the
SQLAgentMail service) but does not want to install Outlook on the server.
They are fairly immutable on this point.
Is there any other way to create the mail profile without installing outlook.
I realize you can use CDO to send mail, but I want to leverage the operator
notification features of Jobs and Alerts.
Thanks,
SG
At this time, Outlook is the only MAPI provider available. You can use some
alternative email tools, most notably xp_smtp_sendmail from www.sqldev.net.
They are not drop-in replacements for SQL Mail, but can do most all of the
functions with some extra work on your part to glue things together. I have
had good results with no impact on system performance or stability.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Giles" <Steve Giles@.discussions.microsoft.com> wrote in message
news:CBDC5B22-02FB-43EA-B164-F8FB500AD170@.microsoft.com...
> Hi,
> I have a client that wants to take advantage of SQL Mail (particularly the
> SQLAgentMail service) but does not want to install Outlook on the server.
> They are fairly immutable on this point.
> Is there any other way to create the mail profile without installing
outlook.
> I realize you can use CDO to send mail, but I want to leverage the
operator
> notification features of Jobs and Alerts.
> Thanks,
> SG
|||Thanks Geoff,
"Geoff N. Hiten" wrote:

> At this time, Outlook is the only MAPI provider available. You can use some
> alternative email tools, most notably xp_smtp_sendmail from www.sqldev.net.
> They are not drop-in replacements for SQL Mail, but can do most all of the
> functions with some extra work on your part to glue things together. I have
> had good results with no impact on system performance or stability.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Giles" <Steve Giles@.discussions.microsoft.com> wrote in message
> news:CBDC5B22-02FB-43EA-B164-F8FB500AD170@.microsoft.com...
> outlook.
> operator
>
>
|||There are some words about using SMTP instead of MSPI in SQL Server in below article (all are based
on xp_smtp_sendmail):
http://www.karaszi.com/SQLServer/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve Giles" <Steve Giles@.discussions.microsoft.com> wrote in message
news:7695FA4E-A5E7-4478-A648-250E5833A063@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff,
>
> "Geoff N. Hiten" wrote: