MAPI Logon Failed

  • I have a number of DTS packages sat on an SQL 2000 server. Almost all of them have send mail tasks for notifications of success/failure. A number of the packages are failing on the send mail tasks with the error "Logon failed: MapiLogonEx failed due to MAPI error 273: MAPI Logon Failed"

    I can't understand why some would work while others do not. Its consistent behavior per file, but seemingly random which files are not working.

    Thanks for any help!

  • I see this error occur when the Profile Name in the Send Mail Task properties does not exist on the SQL server.

  • Ah found it, some of the mail tasks were trying to send through a profile which no longer exists - thanks very much for the tip!

  • Maybe could be interesting for you take a look to this KB article

    How to send e-mail without using SQL Mail in SQL Server

    http://support.microsoft.com/kb/312839/en-us

    You can remove dependencies from SQL Mail, and Outlook profiles by using SMTP.

    Regards

    Ramon

    Regards Ramon

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply