SQL Mail

Question

SQL Mail

JM-92548

Ten Centuries

Points: 1108
More actions
September 21, 2005 at 12:54 pm

#166080

Im trying to setup SQL Mail.
I setup a profile in Outlook, In the Server Properties(Security Tab) I have chosen the profile name for SQL Mail and when I test it, it works fine.
I have done the same for the SQL Agent and when I test, its fine.
But when I go into my DTS packages and into Mail task I get an error message
"Unable to get MAPI profiles"
What else do I need to do?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 1

you need to remote desktop into the server and edit the dts, the mapi profile is local. If you try and edit package on own pc, it picks up your mapi profile.

JM-92548 Ten Centuries Points: 1108 More actions · Answer 2

Im working on the server directly.

It's picking up the profile I setup on the server.

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 3

Did you craete the package on another machine and then saved it to the server?

JM-92548 Ten Centuries Points: 1108 More actions · Answer 4

Yes...I thought of that to but...

But when I try to create a new sql mail task it still gives me the same error.

Man is this thing frustrating.

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 5

pretty much out of ideas on this, you could look at using smtp mail via http://www.sqldev.net/xp/xpsmtp.htm I use this on some of my servers and find it less problematic than mapi

Marti Ryan Ten Centuries Points: 1058 More actions · Answer 6

Is both MSSQLServer and MSSQLAgent set up with the same service account? And did you log on to the server with this account to open Outlook?

Try that...just another idea!

-Marti

JM-92548 Ten Centuries Points: 1108 More actions · Answer 7

Everything is now OK.

I rebooted the machine and everything is now working fine.

Thanks for all the help.