SQL Server Angent Mail Profile

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tony (Mcdbexpert_at_hotmail.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 07:35:14 -0700

I had experience the same thing. My workaround was to use
stored procedures. Let me know if your interested.

>-----Original Message-----
>I originally posted this in the sqlserver.programming
group with no luck so
>I thought I would try here.......
>
>I have SQL Server 2000 Version 8.00.194 and Outlook 2003
SP1. I have a mail
>profile named Exchange set up that uses an Exchange
server. I can send and
>receive email in Outlook. Outlook is the default mail
client and the
>Exchange profile is the default (and only) profile. In
the SQL Server Agent
>properties Mail profile dropdown
>list there are no profiles to select from. If I manually
type in the name
>of the profile and click on Test, I get an error message
that says:
>Error 18030: xp_test_mapi_profile: Either there is no
default mail client or
>the current mail client cannot fulfill the messaging
request. Please run
>Microsoft Outlook and set it as the default mail client.
I have uninstalled
>and reinstalled Outlook, deleted and recreated the
Exchange profile, and
>made sure that Outlook is the default mail client. Both
the SqlServer and
>SqlServerAgent services are running as the user that I
setup the profile
>with and tested with. None of this has solved the
problem. I have 12 other
>servers that are set up like this and they all work. Can
anyone help
>please?
>
>
>.
>

Relevant Pages

  • Re: Extended MAPI without Outlook
    ... Here is the sequence up to the OpenMsgStore: ... but the profile that was just ... OutlookSpy - Outlook, CDO ... mail client or the current mail client cannot fulfill the messaging ...
    (microsoft.public.win32.programmer.messaging)
  • Cannot Create MAPI.Session object when ...
    ... I got the following popup box. ... "Either there is no default mail client or the current mail client ... When the user's default mail client is not Outlook and create ... is there any profile for local outlook without any exchange server? ...
    (microsoft.public.outlook.program_vba)
  • Re: SQL Server Angent Mail Profile
    ... I rebooted the server and it started to work... ... > profile named Exchange set up that uses an Exchange server. ... Outlook is the default mail client and the ... > the current mail client cannot fulfill the messaging request. ...
    (microsoft.public.sqlserver.setup)
  • Re: Integrating SQLServer and Exchange
    ... MAPI profile without actually needing a mail client of any sort. ... > This feature of SQL requires you install a mail client (ie outlook). ... >> When setting up SQL Server 2000 Standard or Enterprise, ...
    (microsoft.public.windows.server.sbs)
  • Re: Business Contact Manager fails
    ... profile but not Exchange profile. ... Special Edition Using Microsoft Outlook 2003 ... BCM claims to install ...
    (microsoft.public.outlook.contacts)