Initialization of MAPI Failed

Posted on 2006-05-04
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
Question by:trojan_uk
    LVL 20

    Accepted Solution

    Check this

    What service pack do you have?

    Author Comment

    Thanks Sirees

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

    Many thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now