 | |
Unable to get MAPI profiles
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Unable to get MAPI profiles -
02-25-2005
, 10:13 AM
#2
| |||
| |||
|
|
Hello All, I am trying to use a send mail task in a DTS job, when I add the task to the designer the following error dialog appears: Title = DTS Designer Error Msg = Unable to get MAPI profiles. If I click Ok the dialog goes away and the send mail properties are displayed but the profiles list is empty. I do have a profile configured and am successfully using it for SQLMail and to send mail via the SQLServerAgent. As always any help is appreciated, Steve Skidmore |
#3
| |||
| |||
|
|
Remember DTS I a client side tool, so unless you are logged onto the server console, with the service account you cannot see the profile you expect. Because of this and my hatred for MAPI in server environments I suggest you don't bother with this task and try one of these- SMTP Mail Task (http://www.sqldev.net/dts/SMTPTask.htm) XPSMTP (http://www.sqldev.net/xp/xpsmtp.htm) "Steve Skidmore" <SteveSkidmore (AT) discussions (DOT) microsoft.com> wrote in message news:0EEB4067-1CB7-4FF2-A5DD-4AD3C29B4E49 (AT) microsoft (DOT) com... Hello All, I am trying to use a send mail task in a DTS job, when I add the task to the designer the following error dialog appears: Title = DTS Designer Error Msg = Unable to get MAPI profiles. If I click Ok the dialog goes away and the send mail properties are displayed but the profiles list is empty. I do have a profile configured and am successfully using it for SQLMail and to send mail via the SQLServerAgent. As always any help is appreciated, Steve Skidmore |
#4
| |||
| |||
|
|
I should have mentioned that. I am logged into the server as the service account and the profile was created for the service account and has been working when used with SQL mail. "Darren Green" wrote: Remember DTS I a client side tool, so unless you are logged onto the server console, with the service account you cannot see the profile you expect. Because of this and my hatred for MAPI in server environments I suggest you don't bother with this task and try one of these- SMTP Mail Task (http://www.sqldev.net/dts/SMTPTask.htm) XPSMTP (http://www.sqldev.net/xp/xpsmtp.htm) "Steve Skidmore" <SteveSkidmore (AT) discussions (DOT) microsoft.com> wrote in message news:0EEB4067-1CB7-4FF2-A5DD-4AD3C29B4E49 (AT) microsoft (DOT) com... Hello All, I am trying to use a send mail task in a DTS job, when I add the task to the designer the following error dialog appears: Title = DTS Designer Error Msg = Unable to get MAPI profiles. If I click Ok the dialog goes away and the send mail properties are displayed but the profiles list is empty. I do have a profile configured and am successfully using it for SQLMail and to send mail via the SQLServerAgent. As always any help is appreciated, Steve Skidmore |
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#5
| |||
| |||
|
|
Ok, so there is a profile available, but the task thinks there isn't Can you confirm the profile is still there by looking in Mail in Control Panel, then Show Profiles. Also open EM and go to SQL Mail, do you get the profile listed in the drop-down? If it is there, then I have no idea. Some bug or maybe permissions related, but doesn't make too much sense if the profile is available for SQL Mail as well. I still stick by my previous recommendation, regardless of the cause. In message <808B98AE-B156-45F6-B3AE-6BA2C235E667 (AT) microsoft (DOT) com>, Steve Skidmore <SteveSkidmore (AT) discussions (DOT) microsoft.com> writes I should have mentioned that. I am logged into the server as the service account and the profile was created for the service account and has been working when used with SQL mail. "Darren Green" wrote: Remember DTS I a client side tool, so unless you are logged onto the server console, with the service account you cannot see the profile you expect. Because of this and my hatred for MAPI in server environments I suggest you don't bother with this task and try one of these- SMTP Mail Task (http://www.sqldev.net/dts/SMTPTask.htm) XPSMTP (http://www.sqldev.net/xp/xpsmtp.htm) "Steve Skidmore" <SteveSkidmore (AT) discussions (DOT) microsoft.com> wrote in message news:0EEB4067-1CB7-4FF2-A5DD-4AD3C29B4E49 (AT) microsoft (DOT) com... Hello All, I am trying to use a send mail task in a DTS job, when I add the task to the designer the following error dialog appears: Title = DTS Designer Error Msg = Unable to get MAPI profiles. If I click Ok the dialog goes away and the send mail properties are displayed but the profiles list is empty. I do have a profile configured and am successfully using it for SQLMail and to send mail via the SQLServerAgent. As always any help is appreciated, Steve Skidmore -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.