sql mail and outlook 2003

Question

sql mail and outlook 2003

MickyD

SSCarpal Tunnel

Points: 4601
More actions
August 30, 2005 at 2:20 pm

#110178

Hi folks
I know there is a bit of comment on this subject , I tried to get my head round it but could get no where. Please , please can any one help me out.
Bit of history need to recieve email alerts from SQL 2000 SP4 running on W2003.
Had the ops guys set up Outlook 2003 ( not custom ) just standard.
Tried various approaches to having Outlook running , not running etc while trying to send mail
SQLAgent error log reports : (264) An attempt was made to send email when no email session had been established.
Tested email from SQL Agent properties , and msg successfully start mapi session for this profile.
Great me thinks , moves on to test job reporting , but no error as above back in error log and no email received.
Have I missed something massive here ?
Really could do with some advice as I am struggling....
Thanks for your time everyone.

Viewing 5 posts - 1 through 4 (of 4 total)

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

jcobble SSC Enthusiast Points: 181 More actions · Answer 1

What account are the SQL and SQL Agent services running under? If not a domain user, then you will need to execute the xp_startmail stored procedure to start the mail session, providing the sp with user and password. Also, are you using exchange?

MickyD SSCarpal Tunnel Points: 4601 More actions · Answer 2

Hi , thanks for the reply.

What account are the SQL and SQL Agent services running under?

These are running both under the same domain account.

Also, are you using exchange

Not an expert on this , we are using an SMTP server.

Is that any help ?

dharper3 SSCrazy Points: 2391 More actions · Answer 3

These MS articles should answer all your questions

http://support.microsoft.com/kb/263556/EN-US/

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886&sd=tech

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 4

Since you stated "Had the ops guys set up Outlook 2003 ( not custom ) just standard.", this is the issue.

You must use the Outlook custom installation option in order to install the CDO library that SQL Mail uses. In Outlook 2003 Custom installation, this is the item named "Collaboration Data Objects", which is not installed by default.

Andy