SQL Server Performance Forum – Threads Archive

MAPI ERROR

For some reason I cant get SQLMail or Agent Mail to work on one of my servers. I have intalled an uninstalled Outlook, created and recreated Mail Profiles set at default. I am<br />working with 2000 sp3a. I get the following error when I test the mail service <br />ERROR 1805<img src=’/community/emoticons/emotion-12.gif’ alt=’:x’ />p_test_mapi_profile<br /><br />Cheers!

Agent service is running as local administrator Cheers!

Check: http://support.microsoft.com/default.aspx?kbid=822177&product=exch2003 HTH Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

I not running exchange Im running Linux mail server. Cheers!

Never used linux mail server, make sure the account used to configure mail profile with Linux has necessary privileges on SQL Box. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

On the SQLBox, log in with the account that SQL/SQLAgent are running as. Whilst logged in at the console make sure that you can use Outlook to send and receive email. If you can do this, then SQLServer should be able to as well. Usually easiest to have SQL and SQLAgent both running under the same account (and both NOT as a local/domain administrator) Cheers
Twan

May also try restart SQLAgent service to test the profile.
The SQL Mail feature of SQL 2K does not work if Outlook 2000 is not installed on the server that functions as the mail client. It supports extended MAPI, and needs the client DLLs to be able to work with MAPI in a service.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>