Post reply

xp_sendmail

  • June 11, 2003 at 3:20 pm

    #59239

    In my server, the SQLServer service and AgentService are started with different user accounts. Outlook is installed on the server.

    While Agentservice sends mail, my xp_sendmail is not working. Any idea ?

  • June 11, 2003 at 3:35 pm

    #460895

    Can you use the same account for both services?

  • June 11, 2003 at 3:43 pm

    #460900

    Thats what I want to do. It is really hard to get a window to do it in my production.

    I did in one of my test servers, and it works. Why does it need to be with the same account? Do I need to create a profile in outlook for it?

  • June 11, 2003 at 8:18 pm

    #460937

    yes. you need to login as the service account and install a mapi client on the server.

  • June 12, 2003 at 4:14 pm

    #461166

    There are often problems with the MAPI profiles, even when they have been set up correctly. You must log on to the server with the accout that is being used to run SQL Server and the Server Agent, create MAPI profiles and then send a test message to make sure. They do not have to use the same accounts, but it will make your life easier.

    I get the best results when using Outlook 2000 SR1.

  • June 18, 2003 at 10:19 am

    #461941

    I fined that using smtp is just as good

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

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