SQL Mail

[ADCC]

Can anyone give me a detailed procedure regarding how to install SQL Mail
in MSSQL 7 ?
I am having problems regarding the MAPI Profile.

[Jason Catlett]

Create an NT User named something like SQLUser.
Log into the SQL Server Machine under that ID
Setup the MAPI Profile for the User.
Go into services and make sure SQL Agent and SQL Server are setup to run
under the context of SQLUser.
Stop and restart the services.
Logout and log back in under your own ID
Now launch Enterprise Manager and under properties for SQL Mail, the profile
you set up earlier should be in the drop down.(EM will query your mail
server for all the profiles for the user SQL Server is started under and put
them in the drop down).

That should do it.

Jason Catlett
FES


"ADCC" <adcctrs@yahoo.com> wrote in message news:38d99cff$1@news.devx.com...
>
> Can anyone give me a detailed procedure regarding how to install SQL Mail
> in MSSQL 7 ?
> I am having problems regarding the MAPI Profile.