Post reply

SQLMail

  • February 2, 2010 at 2:49 am

    #386227

    All

    I am having a few issues with SQLMail since Saturday before it was working as expected.

    Using xp_sendmail, xp_startmail etc we get the following messages

    xp_sendmail: failed with mail error 0x80040111

    xp_test_mapi_profile; failed with mail error 0x80040111

    Looking at the HEX code it relates to mapi_e_logon_failed, both the SQLAgent and MSSQLSERVER login as the same domain account.

    The MAPI profile has been created by the service account.

    SQLAgentMail works fine (DTS package emails etc)

    But nothing relating to xp_sendmail works.

    I have outlook 2003 installed on the server and the profile can see exchange and pull back all the information

    Just stumped as to why it has all of a sudden stopped working.

    Restarted the services aswell

    Thanks

    Ant

  • February 2, 2010 at 5:11 am

    #1112189

    Try:

    http://www.ureader.com/msg/1161666.aspx

    To resolve this problem:

    1. I changed Log On information of MSSQLServer from Windows Services.

    2. I also changed Log On information of SQLServerAgent from Windows

    Services.

    To do 1 & 2 go to Windows Services window, select MSSQLSERVER and

    SQLSERVERAGENT services one by one. Select Log On tab. Select "This

    Account" option button instead of "Local System Account" option button.

    And put my domain user acount and password as domain\userid. Domain must be the same to which I was logged in. And lastly restarted the services.

    3. Then I configured Profile information. To do this explore Control

    Panel. Click on Profile icon. Removed the added email account

    information and then added it again.

    4. Now open Enterprise Manager of SQL and went to Database Server

    Properties window. Selected Server Setting tab. Clicked on Change button in area SQL Main and select the profile from the combo.

    5. Now I went to SQL SErver Agent's propeties window and selected the

    prfile name in Mail Session area.

    6. Again I restarted MSSQLSERVER, SQLSERVERAGENT, Performance Log and Alerter services from Windows Services window.

    And it worked...

    HTH!

    MJ

  • February 2, 2010 at 5:32 am

    #1112192

    I have already done this.

    Both services run as the same account.

    Recreated the MAPI profile

    All services restarted

    Server rebooted

    Thanks

    Ant

  • February 2, 2010 at 5:51 am

    #1112203

    We had the same error message with our Server. One thing that I remember from it that it will work if you are using a SQL login but if you use NT Authentication it will not. To fix the problem we had to rebuild the profile and then stop and start the sql mail service. There may have been a server reboot in there also.

    http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20178037.html

    MJ

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

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