Yuling,
It sounds like you have mail in SQL Agent setup and running
fine but that SQL Mail is having some problems. You can have
one set up and not the other or one working and not the
other. Hard to say what exactly but I'd venture a guess that
maybe they are using different mail profiles or you have SQL
Agent service setup with one domain account and SQL Server
service using another? Just a guess but if either of those
apply, you'd want to look into those issues and how they are
configured differently.
However, these knowledge base articles should help out in
understanding and troubleshooting your mail issues:
INF: How to Configure SQL Mail (Q263556)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556
INF: Common SQL Mail Problems (Q315886)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
INF: Frequently Asked Questions - SQL Server - SQL Mail
(Q311231)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231
Hope that helps -
--Sue
On Fri, 15 Mar 2002 12:03:25 -0800, Yuling Tu
>Sue,
>Thank you for your info. The SQL Mail on Support Servive is started and
>SQL Agent Mail send the notification to me everyday. But, the software
>of Spotlight on SQL indicated that SQL Mail is not installed????
>On SQL server log, a statement "SQL Mail session started", I believe
>it's SQL Mail, isn't it? If you don't have SQL Mail, can you setup SQL
>Agent Mail?
>Recently, I tried to create a package with send mail task, but I got the
>error message -- Initialization of MAPI failed. Please make sure that
>you have messaging service installed on this machine. SQL Mail is
>running and I can receive notification. Which MAPI does this message
>mean?
>Thank you again for your help.
>Yuling
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!
by