Unable to start mail session in SQL Server 7

Unable to start mail session in SQL Server 7

Post by han » Sun, 28 Oct 2001 02:43:24


I am unable to start SQL Mail session using either
Enterprise Manager or TSQL command.  But, I am able to
send mail from job using notification option in job.  I
don't know why. Thanks in advance for any help.



Unable to start mail session in SQL Server 7

Post by Umachandar Jayachandra » Tue, 30 Oct 2001 00:19:50

    It will help if you indicate what error message you are getting. Do you
have profile setup for SQL Server too. Remember you have to do it in two
places - one for the Agent & another for SQLMail.

Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )


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. select date range of one day

3. Unable to start mail session ???

4. problem with update anywhere replication between DB2 Win2000 <-> DB2 AS/400

5. Configuring SQL Server 6.0 to Start Microsoft Mail Session

6. ???? what do I need for SQL-NET ????

7. Failed to start SQL Mail session

8. Error 17952 Failed to Start SQL Mail Session

9. Failed to start SQL Mail session?

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

11. Unable to start Sql Mail Service

12. Unable to Start Session