HI all,

I am trying to use SQL mail for my backups related alerts. I am just starting to configure and a little confusion is related to Exchange Server.

Can some very clearly say if it is must to install MS-Exchange Server to creat a mail profile.

My server has EUDORA mail client which is MAPI compient. We have out mail Server situated at USA and servers are interconnected all the time.

Please advice if Setting up MS-Excahnge Server is must on the Local Server machine.

Hope to get a clear answer soon...

B. Anant

__________________
B. Anant

You do not configure ms exchange on the same machine as SQL Server. Just create a mail profile using your mapi compatible mail client application.

Log on the machine with the account you setup to run your services and create the mail profile and then configure SQL to use the profile for mail services.

How to set the mail profile for SQL Server Agent (Enterprise Manager)
To set the mail profile for SQL Server Agent

Expand a server group, and then expand a server.


Expand Management, right-click SQL Server Agent, and then click Properties.


Under Mail session, select a profile in the Mail profile box. If no profiles are listed, enter the name of the profile to use.

you can also use xp_sendmail. The information is in Books Online