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

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

Post by P l a n » Thu, 13 Dec 2001 23:24:51



Hi all,
I am trying to start the sql mail service on MS Sql Server 7 and I get the
following error:
Error 17952: Failed to start SQL Mail Session

Any hints or tips please. I would appreciate it!

thanks in advance!

 
 
 

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

Post by Intermedia.NE » Thu, 13 Dec 2001 23:36:46


Hello!

PSS ID Number: Q153159
Article last modified on 07-11-1997

6.0 6.5

WINDOWS

======================================================================
------------------------------------------------------------
The information in this article applies to:

 - Microsoft SQL Server, versions 6.0 and 6.5
------------------------------------------------------------

SUMMARY
=======

You can use certain basic troubleshooting techniques to diagnose and
resolve most SQLMail problems. Typically, errors in starting a SQLMail
session or sending mail from SQLMail with a Microsoft Exchange Server
fall
into two categories: permissions problems and Exchange client setup
problems. SQLMail functionality is documented in the "Books Online" for
version 6.x. These should be thoroughly reviewed before using SQLMail.

MORE INFORMATION
================

You should examine the following checklist of items, preferably in the
order given:

1. Log on to Windows NT with a user account that is an administrator of
   the local computer and is a domain account.

2. Confirm that the Exchange client, EXCHNG32.EXE, can connect to the
   Exchange server and mail can be sent.

3. Confirm that the Exchange profile used does not have a Personal
   Message Store (.pst) by running the Mail and Fax tool in Control
   Panel. Click the Show Profiles button and in the Mail dialog box
select
   the default profile in the profile list according to the drop-down
list
   labeled "When starting Microsoft Exchange, use this profile." Click
the
   Properties button.

--
Intermedia.NET (APP)
Microsoft Certified Solutions Provider
Providing expertise in hosting applications
MS Exchange Hosting: http://www.intermedia.net/exchangehosting
Windows 2000 Web Hosting: http://www.intermedia.net/webhosting
For a waiver of the set up fee use "IMFREE" code



Quote:> Hi all,
> I am trying to start the sql mail service on MS Sql Server 7 and I get the
> following error:
> Error 17952: Failed to start SQL Mail Session

> Any hints or tips please. I would appreciate it!

> thanks in advance!


 
 
 

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

Post by P l a n » Thu, 13 Dec 2001 23:57:11


I also meant to say that I do have outlook 2k client on this. But our mail
system is lotus notes. I am able to send mail from this client. (via pop3)

Just cannot start any sql mail service


Quote:> Hi all,
> I am trying to start the sql mail service on MS Sql Server 7 and I get the
> following error:
> Error 17952: Failed to start SQL Mail Session

> Any hints or tips please. I would appreciate it!

> thanks in advance!

 
 
 

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

Post by Dwayne Lanclos [M » Sat, 15 Dec 2001 05:02:17


You don't "send" mail using POP3, you "receive" mail using POP3.  You use
SMTP to send mail.  Your Lotus Notes server must be set up as a POP3 server
in order to use it with SQL Mail because the Outlook configuration requires
both a POP3 server (for incoming mail) and an SMTP server (for outgoing
mail).  Even if there are no plans to ever send mail to SQL Server, a POP3
server MUST be configured in the mail profile.

That said, the most likely reason that you cannot start SQL Mail is either
because you failed to provide a working mail profile or your server's
default mail client is something other than "Microsoft Outlook".  See
Q263556, "How to Configure SQL Mail" for all the details.

------
Dwayne Lanclos
Microsoft SQL Server Support

Please reply only to the newsgroup so that others can benefit.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------


> I also meant to say that I do have outlook 2k client on this. But our mail
> system is lotus notes. I am able to send mail from this client. (via pop3)

> Just cannot start any sql mail service


> > Hi all,
> > I am trying to start the sql mail service on MS Sql Server 7 and I get
the
> > following error:
> > Error 17952: Failed to start SQL Mail Session

> > Any hints or tips please. I would appreciate it!

> > thanks in advance!

 
 
 

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

Post by P l a n » Sat, 15 Dec 2001 22:47:29


Yes Dwane I understand all that you said perhaps I did not convey correctly.
I do knwo the diff. between pop3 and smtp. Thing IS I cannot SEND email.
I did use that Q article and it still does not work.

thanks for chiming in.

Now I get errors such as  22030



> You don't "send" mail using POP3, you "receive" mail using POP3.  You use
> SMTP to send mail.  Your Lotus Notes server must be set up as a POP3
server
> in order to use it with SQL Mail because the Outlook configuration
requires
> both a POP3 server (for incoming mail) and an SMTP server (for outgoing
> mail).  Even if there are no plans to ever send mail to SQL Server, a POP3
> server MUST be configured in the mail profile.

> That said, the most likely reason that you cannot start SQL Mail is either
> because you failed to provide a working mail profile or your server's
> default mail client is something other than "Microsoft Outlook".  See
> Q263556, "How to Configure SQL Mail" for all the details.

> ------
> Dwayne Lanclos
> Microsoft SQL Server Support

> Please reply only to the newsgroup so that others can benefit.
> When posting, please state the version of SQL Server being used and the
> error number/exact error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
rights.

> --------------------

> > I also meant to say that I do have outlook 2k client on this. But our
mail
> > system is lotus notes. I am able to send mail from this client. (via
pop3)

> > Just cannot start any sql mail service


> > > Hi all,
> > > I am trying to start the sql mail service on MS Sql Server 7 and I get
> the
> > > following error:
> > > Error 17952: Failed to start SQL Mail Session

> > > Any hints or tips please. I would appreciate it!

> > > thanks in advance!

 
 
 

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

Post by Dwayne Lanclos [M » Sun, 16 Dec 2001 01:39:15


Error 22030 is very generic.  I would need the entire error message to
speculate on what the problem could be.  Are you sure that your Lotus Notes
client is open on the POP3 port?  Or are you providing another server as
your POP3 server?  You need to have a configured and working POP3 server
even if your only desire is to send SMTP mail.

------
Dwayne Lanclos
Microsoft SQL Server Support

Please reply only to the newsgroup so that others can benefit.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------


> Yes Dwane I understand all that you said perhaps I did not convey
correctly.
> I do knwo the diff. between pop3 and smtp. Thing IS I cannot SEND email.
> I did use that Q article and it still does not work.

> thanks for chiming in.

> Now I get errors such as  22030



> > You don't "send" mail using POP3, you "receive" mail using POP3.  You
use
> > SMTP to send mail.  Your Lotus Notes server must be set up as a POP3
> server
> > in order to use it with SQL Mail because the Outlook configuration
> requires
> > both a POP3 server (for incoming mail) and an SMTP server (for outgoing
> > mail).  Even if there are no plans to ever send mail to SQL Server, a
POP3
> > server MUST be configured in the mail profile.

> > That said, the most likely reason that you cannot start SQL Mail is
either
> > because you failed to provide a working mail profile or your server's
> > default mail client is something other than "Microsoft Outlook".  See
> > Q263556, "How to Configure SQL Mail" for all the details.

> > ------
> > Dwayne Lanclos
> > Microsoft SQL Server Support

> > Please reply only to the newsgroup so that others can benefit.
> > When posting, please state the version of SQL Server being used and the
> > error number/exact error message text received, if any.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.

> > --------------------

> > > I also meant to say that I do have outlook 2k client on this. But our
> mail
> > > system is lotus notes. I am able to send mail from this client. (via
> pop3)

> > > Just cannot start any sql mail service


> > > > Hi all,
> > > > I am trying to start the sql mail service on MS Sql Server 7 and I
get
> > the
> > > > following error:
> > > > Error 17952: Failed to start SQL Mail Session

> > > > Any hints or tips please. I would appreciate it!

> > > > thanks in advance!

 
 
 

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

Post by P l a n » Sun, 16 Dec 2001 06:08:57


Got it working finally..



> Error 22030 is very generic.  I would need the entire error message to
> speculate on what the problem could be.  Are you sure that your Lotus
Notes
> client is open on the POP3 port?  Or are you providing another server as
> your POP3 server?  You need to have a configured and working POP3 server
> even if your only desire is to send SMTP mail.

> ------
> Dwayne Lanclos
> Microsoft SQL Server Support

> Please reply only to the newsgroup so that others can benefit.
> When posting, please state the version of SQL Server being used and the
> error number/exact error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
rights.

> --------------------

> > Yes Dwane I understand all that you said perhaps I did not convey
> correctly.
> > I do knwo the diff. between pop3 and smtp. Thing IS I cannot SEND email.
> > I did use that Q article and it still does not work.

> > thanks for chiming in.

> > Now I get errors such as  22030



> > > You don't "send" mail using POP3, you "receive" mail using POP3.  You
> use
> > > SMTP to send mail.  Your Lotus Notes server must be set up as a POP3
> > server
> > > in order to use it with SQL Mail because the Outlook configuration
> > requires
> > > both a POP3 server (for incoming mail) and an SMTP server (for
outgoing
> > > mail).  Even if there are no plans to ever send mail to SQL Server, a
> POP3
> > > server MUST be configured in the mail profile.

> > > That said, the most likely reason that you cannot start SQL Mail is
> either
> > > because you failed to provide a working mail profile or your server's
> > > default mail client is something other than "Microsoft Outlook".  See
> > > Q263556, "How to Configure SQL Mail" for all the details.

> > > ------
> > > Dwayne Lanclos
> > > Microsoft SQL Server Support

> > > Please reply only to the newsgroup so that others can benefit.
> > > When posting, please state the version of SQL Server being used and
the
> > > error number/exact error message text received, if any.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.

> > > --------------------

> > > > I also meant to say that I do have outlook 2k client on this. But
our
> > mail
> > > > system is lotus notes. I am able to send mail from this client. (via
> > pop3)

> > > > Just cannot start any sql mail service


> > > > > Hi all,
> > > > > I am trying to start the sql mail service on MS Sql Server 7 and I
> get
> > > the
> > > > > following error:
> > > > > Error 17952: Failed to start SQL Mail Session

> > > > > Any hints or tips please. I would appreciate it!

> > > > > thanks in advance!

 
 
 

1. Error 17952 Failed to Start SQL Mail Session

Hello...

I'm trying to start the SQL Mail with Windows Messaging 4.0.0993.3 and
Microsoft Mail.

In the Books Online I only found information about the configuration with
MSMail32... but I using Windows Messaging (Exchange).

I always receive the following error message:
Microsoft SQL-DMO : "Error 17952  Failed to  Start SQL Mail Session. Check
the error log file in the  SQL Server directory for detail"

InSQLExec.out these are the entries:

7/14/98 7:23:19 PM - ? SQL Executive version 6.50.240
7/14/98 7:23:19 PM - ? SQL Server version 6.50.281
7/14/98 7:23:19 PM - ? DB-Library version 6.50.252
7/14/98 7:23:19 PM - ? SQLExecutive Service Started
..........
7/14/98 7:23:32 PM - ? Starting Microsoft Mail session using account
'OBELIX'...
7/14/98 7:23:32 PM - + DBLib Message Handler: Failed to start SQL Mail
session.

Any help appreciated.

Thanks,
Paloma Queimadelos

Please direct replies to news group. Thanks.

2. simple Q: PWIN 4.5

3. SQL Mail - Failed to start SQL Mail session

4. Where can I find Installer 3.3.1.2.4 Please?

5. SQL Mail Icon (17952 error)

6. Help with joining one to many table

7. SQL mail error: MAPI Logon Failure 17952

8. Building a standalone application from Approach?

9. sql mail error 17952

10. SQL Mail and MS Excange Server 5 Trouble Error 17952

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

12. Failed to start SQL Mail session

13. Failed to start SQL Mail session?