Solved

Failed to start the SQL Mail Session

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

760 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

21 Experts available now in Live!

Get 1:1 Help Now