SQL Mail

SQL Mail

Post by Victo » Tue, 07 Nov 2000 04:00:00

What I'm doing wrong? I configured the SQL Mail and SQLAgentMail using POP3 mail
server. I can send and recieve email using Outlook also I can send email to an
Operator but I keep getting Dr. Watson error once I click the ok button on the
operator screen. (mmc.exe exception access violation). I have search through
knowledge base and book online and still I don't have any clue on how to fix this


1. SQL Mail - Failed to start SQL Mail session


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,


2. Avg by year and qtr

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

4. vxfs and Oracle db_file_multiblock_read_count

5. SQL server 7 agent mail / SQL mail setup questions


7. SQL Mail vs SQL Agent Mail

8. Run-time error '91'

9. SQL Mail (SQL-2000) via Lotus cc:Mail (DB8)

10. Setting up SQL Agent Mail and SQL Mail

11. Send E-Mail Without Using SQL Mail in SQL Server (Q312839)

12. Send E-Mail Without Using SQL Mail in SQL Server

13. sql mail and sql agent mail