Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, October 12, 2015 3:34 AM
Points: 14, Visits: 62
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: Thursday, October 15, 2015 1:10 PM
Points: 633, Visits: 1,697
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: Monday, October 12, 2015 3:34 AM
Points: 14, Visits: 62
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: Friday, December 4, 2015 8:36 AM
Points: 574, Visits: 121
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