Solved

Failed to start the SQL Mail Session

Posted on 2001-06-19
3
293 Views
Last Modified: 2012-06-27
I am running SQL Server 6.5 under Windows NT 4.0. I tried starting SQL Mail and got the following error:

Error:17952, Severity. 18, State: 1
Failed to start SQL Mail session
OS Error: 126, The specified module could not be found

How can this error be resolved?  I am fairly certain that SQL Mail was installed.  As a matter of fact, I don't even remember that being optional.
0
Comment
Question by:geowilli
  • 2
3 Comments
 
LVL 2

Expert Comment

by:ZhongYu
ID: 6209395
Have you installed MS Outlook?

You must install Outlook and login to the NT server as the acount that SQL server and Executive are running, create a mail profile and test it. Then the SQL mail will work.

I must say that I do not like it.

0
 
LVL 1

Author Comment

by:geowilli
ID: 6211680
ZhongYu

I have not installed outlook.  I only have outlook express installed.  In any case, I will not be able to test your solution now since I am away from the server today.  Please bear with me until tomorrow when I will be able to respond to you and give you your points.
0
 
LVL 2

Accepted Solution

by:
ZhongYu earned 100 total points
ID: 6213622
One more thing, you must use the mail profile in the SQL mail.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question