Board index MS SQL Server

SQL Mail test fails with MAPILogonEx error, SQL Mail starts only when Outlook open

SQL Mail test fails with MAPILogonEx error, SQL Mail starts only when Outlook open

Post by Alex Vorobi » Wed, 30 Jan 2002 02:35:26



nt 4.0, service pack 6
sql server 7.0
outlook 2000

i went through the microsoft article(s) step by step:

-> installed outlook 2000
-> made sure no old mapi32.dll are lingering, only new one is present
-> logged in as domain admin, ie the same user that runs sql server and agent
-> created profile that connects to pop3/smtp server
-> tested the setup via outlook - mail is successfully delivered

i cannot start sql mail UNLESS outlook is opened.  once i open outlook, sql
mail starts up fine,
and i can execute a test call to xp_sendmail - messages go out and arrive at
their destination.
i do, however, have the following two problems:

1. clicking the Test button always fails with "Error 22030: A MAPI
error(error number :273) MapiLogonEx Failed due to
error 273:.."
2. sql mail would not start unless outlook is open.

any help would be appreciated.

thanks!

--sasha

 
 
 
Top

SQL Mail test fails with MAPILogonEx error, SQL Mail starts only when Outlook open

Post by sybor » Sat, 02 Feb 2002 06:31:42


I would recommend the cdo com object for sending mail - if you have
win 2000 or NT 4. Here is a sproc that will do it. Also make sure you
have IIS running, and have configured an SMTP server to run (check the
services)...


AS









GO

 
 
 
Top

SQL Mail test fails with MAPILogonEx error, SQL Mail starts only when Outlook open

Post by sybor » Sat, 02 Feb 2002 06:31:42


I would recommend the cdo com object for sending mail - if you have
win 2000 or NT 4. Here is a sproc that will do it. Also make sure you
have IIS running, and have configured an SMTP server to run (check the
services)...


AS









GO

 
 
 
Top

1. SQL Mail - Failed to start SQL Mail session

Hi,

I have followed the previous threads on the subject and can't get SQL Mail
to work with an Outlook Internet service on the same machine.  (I haven't
got it to work with anything else either, as Internet mail is all I have :-)

I am set up like this (names changed to protect the guilty).

Logged into NT 4. as "adminguy" with password "adminpass".
SQL Server configured for "NT Security".
"Profile Name" in Outlook "adminguy".
The "adminguy" Outlook profile has only the "Internet mail" Service.
"adminguy's" Internet mail is working and he is able to send and receive
mail and I've left Outlook open!

In the SQL Setup, I provide the "Profile Name" of "adminguy".

The documentation shows other fields including password, etc., but with SQL
Server 6.5, I can't find these - only "profile name".

Now when I try to start the service, I get the following error in the log:

98/03/24 15:56:36.02 ods      MAPI login failure.
98/03/24 15:56:36.02 ods      Error : 17951, Severity: 18, State: 1
98/03/24 15:56:36.02 ods      Failed to start SQL Mail session.

Where have I gone wrong? Help please.

Many thanks,

Monu

2. Probs resroting data from DAT file

3. SQL Mail Starts but does not send mail, unless Outlook is open manually

4. MS Access ODBC error

5. SQL Mail Error (xp_sendmail: failed with mail error 0x80040111)

6. Microsoft Access

7. SQL mail using outlook as client side and POP mail server

8. thanks for image database tricks and new question

9. Can't send mail with SQL Mail and Outlook 2002

10. Error 17952: Failed to start SQL Mail Session - HELP PLEASE

11. Error 17952 Failed to Start SQL Mail Session

12. Outlook and SQL mail together fail

13. Error setting up SQL Mail 2000 with Outlook 2000


All times are UTC
Board index