I have a DTS package that scheduled to run nightly but it fails on SQLMail
Task, I get error "MapiLogonEx Failed due to MAPI error 273:MAPI Logon
failed" . This DTS package dumps data into an excel spreadsheet and e-mails
spreadsheet to user in company. I'm using Outlook 2003 client with Exchange
Server 2003. The SQL Server and Agent are using the same domain admin
account and the scheduled task is also setup with same admin account. When I
run the DTS package using DTSRunUI I get Mapi error but if I run it from
Enterprise Mger on my workstation it works no errors. I logged on sql server
with the admin account and the outlook profile is configured. I tested
SQLMail using "EXECUTE master.dbo.xp_sendmail" from QA and user received
message.
Any ideas where to look from here, I stumped.

Thanks in Advance
Rob

Does the profile name set in the send mail task match the profile name that
was created under the service account?
A common issue is to set the profile to your named profile, which may not
match the profile of the service account.

I personally despise MAPI and do not use it. A desktop application running
unattended under a service is just asking for trouble. I'd suggest you try
xp_smtp_send_mail or the Send Mail SMTP task, both from SQLDev.net

SMTP Mail Task
(http://www.sqldev.net/dts/SMTPTask.htm)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Rob" <Rob (AT) discussions (DOT) microsoft.com> wrote

Found problem. It ended up being a space in the folder name where I stored
the excel spreasheet. Eliminated the space and it works. Not sure why I was
getting MAPI errors??? I would assume a "cannot find file" but its working
so I'm not complaining.

thanks
rob



"Darren Green" wrote:

Spoke too soon. Still having problems with MAPI. Has anyone heard of any
issues with Outlook 2003 and SQL Mail. My old SQL server has Outlook 2002
and I have no issues. Any more ideas
thanks
rob

"Rob" wrote:

Search the KB, there are plenty of articles there.

There are issues with the spooler, meaning you need to leave the server
logged on and Outlook running. I forget the details, but I stuck with
Outlook 2000, that was more reliable. This is the problem, MAPI is owned by
Office, and they develop for a desktop application. We use MAPI under a
service, the two just don't fit.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Rob" <Rob (AT) discussions (DOT) microsoft.com> wrote