March 1, 2011 at 11:21 am
I've got everything set up right. I've got the sql mail, Mail profile set up right. the sql server and its agent are running under the same account that the outlook is using. I have a dts job that has 'Send Mail Task'. It's been running fine until this morning. this morning, it failed to email to me. when I tried to open the task property, I got this error message "Unable to get MAPI profiles". Weird thing is that The sql job email notification works fine. Any idea what to do with this?
March 3, 2011 at 8:53 am
mail on sql2000 is a external task and sometimes you have to reboot to fix it
before you reboot try this
login to the machine with the username of the outlook client
send and email, if it doesnt work reboot
if it does go to query analyzer xp_stopmail and xp_startmail
it you get error you probably will have to reboot
otherwise send the a test email from query analyzer
it might take up to 5 minutes to send it
March 7, 2011 at 12:21 pm
Rebooting is very typical solution to Microsoft product issue. It worked perfect. Actually I even had to recreate the dts package. Thank you, sir.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply