MAPI mail profile setup to send SQL mails 1

[joebickley]

HI

I want to send mails from my SQL server. I understand i need to set up a MAPI mail profile on the server to send mails from. Anyone know how. Please dont tell me i have to install outlook on the server!

If is any use the server has the SMTP server installed as part of the NT 4 option pack

Thanks

Joe Bickley

 

[PhillCart]

SQL Mail uses MAPI, so you need a MAPI client on the server. Either Outlook or the Echange Client that comes with NT will suffice.

Then you need to login to the server with the same username that the MSSQLServer service uses. Then you setup a mail profile as you would for a normal user.

Once the profile is created put the profile name in the appropriate spots for SQL Agent and SQL Mail.

 

[Bernadette]

Hi There

Check out the following link

http://support.microsoft.com/support/SQL/Content/HowTos/SQL7Mail.asp?LN=EN-US&SD=gn&FR=0

It is Microsoft's "How To..." paper for SQL Mail.


Hope This Helps Bernadette