SQL Mail Problems

[AndyLee100]

Hope somebody can help with a very frustrating SQL mail problem.

Our company has SQL2000 on a Windows Server 2003. It has MS Exchange installed but it is not being used for the email. There is a separate vpop program running the email. The startup service for SQL is running on a windows NT acccount that has a working MAPI profile that can send and receive emails using Outlook 2003. The security is set for NT authentication.

We trying to start the email service using xp_startmail the error:

SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040107

comes up. Looking on Microsoft to see what the hex error means this says:

MAPI_E_INVALID_ENTRYID 80040107 -2147221241

I was wondering if Exchange has to be removed if this is causing the problem.

Any help would be greatly appreciated.

Thanks

Andy Lee

 

[jgoodman00]

Not sure about removing exchange, but Outlook 2003 is likely to cause problems. SQL Mail was designed for use with Outlook 2000, & seems to have plenty of problems with other versions of Outlook. For this reason I ended up switching back to Outlook 2000 on our SQL Server.
This does not apply if you use Exchange Server.



James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures