?
Solved

Failed to start the SQL Mail Session

Posted on 2001-06-19
3
Medium Priority
?
306 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 300 total points
ID: 6213622
One more thing, you must use the mail profile in the SQL mail.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

864 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