Solved

Failed to start the SQL Mail Session

Posted on 2001-06-19
3
286 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is format f12.8 for a CSV file 6 41
Using Aggregate Functions to Count 3 34
SQL Query stumper 3 37
Executing SSIS with a Stored Procedure Permissions 12 29
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

862 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now