Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Initialization of MAPI Failed

Posted on 2006-05-04
2
Medium Priority
?
1,838 Views
Last Modified: 2012-06-27
OK here goes.

I am trying to add a Send Email Task to a DTS procedure, however I am getting an 'Initialization of MAPI Failed' error when I try to execute this task.

When I check the SQL Server settings it shows SQL mail as the SQL mail, when I click the test button it says successfully started (and stopped) a MAPI session with this profile. Likewise if I go to Support Services and SQL Mail I get the same thing. if I look at SQL Server Agent however the Mail Profile is greyed out and nothing is selected.

If I then go to a client machine connect remotely to the same SQL server open up the DTS and execute the task it runs successfully and sends the email, why is it working on a client machine but not the server itself?

I have outlook 2003 installed on the server but there is no account associated with it and the server is running on Exchange. ANY ideas on this?

Many thanks
0
Comment
Question by:trojan_uk
2 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 1000 total points
ID: 16607173
Check this

http://support.microsoft.com/?kbid=839986

What service pack do you have?
0
 

Author Comment

by:trojan_uk
ID: 16613199
Thanks Sirees

That was in fact the problem, I downloaded sp4 and it solved my problem.

Many thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

577 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