Post reply

Unable to see Mapi Profile from Enterprise Manager in SQL 2000

  • September 25, 2007 at 11:19 am

    #177425

    Hi All,

    I have googled for days on this with no success.

    MS SQL Server 2000 SP4

    MS Outlook 2003, with the latest updates.

    MS Windows 2003 Server Standard edition, with the latest updates.

    I created a MAPI Profile in MS Outlook 2003, which uses Exchange Server. I can login, send, and receive emails directly just fine.

    The user ID is on the active directory with proper admin rights to the machine and is used for to start the MS SQL Server and MSSQL Server Agent in the Control Panel-> Services.

    When I open my local DB using the "sa" account, which also has admin rights to everything, I get the following error when trying to rest the outlook session. Error 18025 xp_test_mapi_profile failed 0x80040111. (Properties->Server Setting->SQL Mail Configuration). The MAPI profile created is NOT listed in the dropdown. Nothing is listed in the dropdown.

    To check to see if other parts are ok, I did a remote login from this machine to another SQL 2000 DB with the same settings. I can test the profile with no problems on 2 other machine.

    What am I missing on this one?

    Any ideas?

    Thanks

  • September 25, 2007 at 11:30 am

    #736108

    is the mail profile you created for the service account that runs sql?

  • September 26, 2007 at 4:33 pm

    #736550

    1.) Did you check the MSSQLSERVER and SQLAGENT service names to see what user they are logging on under? If so, are they both the same username?

    2.) Did you log in directly onto that same physical SQL server with that user and setup outlook, then test it out?

    3.) If so, type xp_sendmail in QA and see if it gives you an error, or if it says @receipient is missing.

    Report back with your findings, thanks.

  • September 27, 2007 at 7:59 am

    #736734

    Hey Hey!!

    I did everything you mentioned except login to the machine as the user and then install Outlook 2003.

    That is strange that I have to login to the machine as that user. I figured that as long as any user with Admin rights was logged in, then I would be ok. I will put this trick in my notes.

    THANKS!!

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

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