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

[dananrg]

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

[Simon Hayes]

<da*****@yahoo.com> wrote in message
news:11*********************@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