Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MAPI Logon Failed Expand / Collapse
Author
Message
Posted Thursday, January 31, 2008 3:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 8:02 AM
Points: 13, Visits: 59
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!
Post #449847
Posted Thursday, January 31, 2008 11:29 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 31, 2012 10:31 AM
Points: 633, Visits: 1,695
I see this error occur when the Profile Name in the Send Mail Task properties does not exist on the SQL server.
Post #450110
Posted Friday, February 1, 2008 1:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 8:02 AM
Points: 13, Visits: 59
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!
Post #450360
Posted Friday, February 1, 2008 3:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 3:54 AM
Points: 554, Visits: 115
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
Post #450377
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse