Post reply

SQL Agent Cannot start a mail session

  • September 17, 2003 at 1:24 pm

    #106293

    I am running SQL Server 2000 SP3 on a Windows 2000 Advanced Server SP2 machine. I am trying to change the sql agent service startup account. With the old account, sql agent is able to send mail using xp_sendmail. With the new account, I get an error when I start the service (that I have posted below.) The new account and the old account are both domain admin accounts. Both have Exchange profiles. Outlook 2000 is installed on the SQL Server and both accounts have Outlook profiles in Outlook. Anyone know what else I need to do? The message I am getting is below:

    [260] Unable to start mail session (reason: Unable to logon (reason: Unable to get the default MAPI Message Store due to MAPI error 273: The information store could not be opened); check the mail profile and/or the SQLSERVERAGENT service startup account)

  • September 17, 2003 at 5:14 pm

    #474770

    Error 273 is a logon failure.

    Can you login to the server using the new account and send emails from Outlook?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 17, 2003 at 5:45 pm

    #474774

    I got similar error earlier. But I screwed-up in my first trail.

    So I logged into the box with service account and setup the mail profile. Then changed the Startup account. Everything went fine.

    Like phillcart said, THE BEST TEST could be loginto the box with the service account, send mails from there. Then you could setup mail profile and change the service account.

    .

  • September 18, 2003 at 7:11 am

    #474861

    Nice link for when you have sqlmail problems:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886#1

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

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