SQL Mail

SQL Mail

Post by Ian T. Jon » Wed, 25 Apr 2001 00:32:18



I am trying to set up SQL mail on my server.  I need help :)

1.  I set up a MAPI profile but am getting this error:

Error 22030: A MAPI Error (error number 87) occured: MapiLogonEX
failed due to MAPI error 87: invalid paramter

I set up the profile verbatim to what it said in the Microsoft book
but to no avail.  Do I have to actually give it a mail server to logon
to or does it not need one?  Any help would be great!!

TIA
Ian

 
 
 

SQL Mail

Post by <Zach_ra.. » Thu, 26 Apr 2001 10:26:55


SQL Server knowledge base has excellent articles about how to set up the email on
the server and also to troubleshoot the err msg. It is how I sat up mine and it
is working fine right now...Keep eye on the SQLagent! I had most of the trouble
with it

Bon Chance!

Quote:-----Original Message-----
I am trying to set up SQL mail on my server.  I need help :)

1.  I set up a MAPI profile but am getting this error:

Error 22030: A MAPI Error (error number 87) occured: MapiLogonEX
failed due to MAPI error 87: invalid paramter

I set up the profile verbatim to what it said in the Microsoft book
but to no avail.  Do I have to actually give it a mail server to logon
to or does it not need one?  Any help would be great!!

TIA
Ian
.


 
 
 

SQL Mail

Post by Mark Langendoerfe » Sat, 05 May 2001 01:53:05


You need outlook2000 for SQLMail to work in SQL2000 as it uses extended
MAPI.

1/ Login as the account SQL Server is using.

2/ Install outlook.

3/ Create a new profile.

4/ Reboot the box

5/ Follow the instructions for config or SQLMail.



Quote:> I am trying to set up SQL mail on my server.  I need help :)

> 1.  I set up a MAPI profile but am getting this error:

> Error 22030: A MAPI Error (error number 87) occured: MapiLogonEX
> failed due to MAPI error 87: invalid paramter

> I set up the profile verbatim to what it said in the Microsoft book
> but to no avail.  Do I have to actually give it a mail server to logon
> to or does it not need one?  Any help would be great!!

> TIA
> Ian

 
 
 

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. CLEVELAND OHIO: Progress / Unix DGUX expert sought (Fulltime)

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

4. Marge replication re-synchronization

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

6. +++++++++++ M S O F F I C E P R O 97 $1 4 5 ++++++++++++

7. SQL Mail vs SQL Agent Mail

8. Open Url

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