Post reply

Mapi on SQL server

  • September 4, 2006 at 3:28 am

    #173802

    Hi,

    I've set some DTS packages to automate reports, when i run them manually they work fine and mail the results as they should. But when i try to schedule them they fail at the send mail stage, can anyone give me any hints as to how i could fix this?

    thanks.

    (I thought that it might be the email settings on the server, but since then i've assigned an email account with identical login and password as the SQL account.)

  • September 4, 2006 at 6:37 pm

    #658448

    If the job doesnot send emails then do u know what account starts the SQL Agent and can that account send emails?

    Hope this helps.

    Thanks

    Sreejith

  • September 5, 2006 at 2:16 am

    #658486

    As SS said, check the SQL Agent service account is mail enabled.  This kb should tell you everything you need: http://support.microsoft.com/kb/263556/

    Cath

  • September 5, 2006 at 6:08 am

    #658504

    Thanks for the help.

    Simon

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

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