Configuring SQLServerAgent 2000 mail session

How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?

Yes you do. More specifically, you need MS Outlook 2000.

Try this link (http://support.microsoft.com/kb/263556). Bear in mind that SQL Agent Mail and SQL Mail are different, and must be configured separately (though you don't have to configure both).

In general, I HATE SQL Agent Mail. If Outlook hangs or whatever reason, you can potentially hang your entire job scheduling process. It can get real ugly real fast.

Google SMTP solutions for SQL 2000 and you'll find a lot of other options. Best bet, though, is to go with SQL 2005 and use the new database mail feature (which is SMTP based).

Regards,

hmscott

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:

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,
SGAt 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...
> > 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
>
>|||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...
> 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...
> > > 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
> >
> >
> >

Configuring mail for SQL Server Agent - Problem with Exchange and Outlook on same machine?

I would like to configure e-mail alerts on my SQL Server 2000 box.
However, we also run Exchange on the same machine. I've been told there
could be conflicts/issues having Outlook on the same machine as
Exchange; and apparently, one needs Outlook to configure a mail profile
for SQL Server Agent.

Is there, in fact, anything to worry about? If so, are there any
work-arounds beside moving Exchange to another server? (we've only got
one server, so this is not an option for us at this time).
Thanks.

- Dana<dananrg@.yahoo.com> wrote in message
news:1106142898.187937.44340@.z14g2000cwz.googlegro ups.com...
> I would like to configure e-mail alerts on my SQL Server 2000 box.
> However, we also run Exchange on the same machine. I've been told there
> could be conflicts/issues having Outlook on the same machine as
> Exchange; and apparently, one needs Outlook to configure a mail profile
> for SQL Server Agent.
> Is there, in fact, anything to worry about? If so, are there any
> work-arounds beside moving Exchange to another server? (we've only got
> one server, so this is not an option for us at this time).
> Thanks.
> - Dana

SQL Mail can sometimes be tricky to set up - you can check the MS Knowledge
Base for detailed articles on setup and troubleshooting. This is one
alternative approach:

http://www.karaszi.com/sqlserver/info_no_mapi.asp

I don't know if there are any problems with Exchange and Outlook on the same
box (you might want to ask in an Exchange group), but moving Exchange (or
MSSQL) to a separate server might be a good idea anyway, to avoid possible
resource conflicts. Although if you've been running both together for a
while, presumably that's not an issue for you right now.

Simon