Post reply

Troubeshooting SQL Mail

  • June 7, 2004 at 1:10 pm

    #359833

    Hi

    First of all I hope that Yucon has a better system !

    Our SQL Mail profile should be ok. But when we want to send :

    Hi

    Have a

    EXEC master..xp_startmail

    EXEC master..xp_sendmail

    @recipients = 'jv@elecenter.be',

    @message = 'test',

    @subject = 'Order van een blocked dealer'

    EXEC master..xp_stopmail

    it doesn't work. Anybody has any idea ???

    Kind regards

    El Jefe


    JV

  • June 7, 2004 at 1:48 pm

    #509315

    What is the error that you receive?


    Shamless self promotion - read my blog http://sirsql.net

  • June 8, 2004 at 12:14 am

    #509383

    It simply doesn't work. The query analyzer is running for about 15 minutes. Then I kill the job.

     

    Kind regards

    Jef


    JV

  • June 8, 2004 at 7:37 am

    #509467

    Don't bother with the xp_startmail, xp_sendmail will also start the mail session.

     

    Try logging on to the server using the sql service account, then go into outlook, check the profile is ok, and send a test email to make sure that everything is working.


    Shamless self promotion - read my blog http://sirsql.net

  • June 8, 2004 at 7:43 am

    #509469

    The crucial things are that the sql server service and the sql agent service be running under a domain service account.  Your SQL Server must have connectivity to your Exchange server.  Your SQL Server must have the Outlook client installed and whoever installs it should be logged on the server as the domain service account that is running SQL.  Last, the Outlook profile must be created for that service account.

    These articles are pretty good:  http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556,   http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231,   http://support.microsoft.com/default.aspx?scid=kb;en-us;315886.  Good luck!

  • June 8, 2004 at 7:52 am

    #509471

    Log in to Outlook using the id u've given to SQL Server agent. and try sending mails manually. If you can't, you have a problem with oulook itself. else you don't have a problem of oulook, need to check mapi setting.

  • June 8, 2004 at 8:16 am

    #509479

    I think the troubleshooting steps already given will help you isolate the problem.

    As a side note, SQL 2005 (Yukon) will have an SMTP based mail solution which will eliminate the need for Outlook on your SQL Server and the associated problems of MAPI running in the SQL address space.


    Regards,
    Steve

    Meddle not in the affairs of dragons, for you are crunchy and taste good with ketchup.

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

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