Re: Integrating SQLServer and Exchange

From: Karl Middleton (nospam_at_nospam.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 11:31:19 +1100

I found a utility on the MS website call PROFMGR that allows you to create a
MAPI profile without actually needing a mail client of any sort. This then
permitted applications such as Backup Exec to communicate via email on
Exchange. A search on the MS site should find it.

"MCSEGURU" <mcseguruhere@aol.com> wrote in message
news:eoJgJV%23BFHA.3824@TK2MSFTNGP10.phx.gbl...
> This feature of SQL requires you install a mail client (ie outlook).
> Outlook is no advisable because SBS is also your Exchange server, and it's
> not advised that you install outlook on your exchange server.
>
> You can try to setup a profile in Outlook Express and use that. Once the
> logged on user (account the SQL Server Agent service is configured to run
> under) has an e-mail profile created in an e-mail program, that feature
> should be accessible.
>
>
>
> <rick@renright.com> wrote in message
> news:YLOdnQJ0drPqOWPcRVn-2Q@giganews.com...
>> When setting up SQL Server 2000 Standard or Enterprise, I often integrate
>> Exchange with SQL Server to allow SQL to send email messages in response
>> to
>> alerts and jobs. I tried doing this in SBS 2003 and the option to add a
>> profile to SQL was not available.
>>
>> How can I do this? One of my clients has a real need to be notified if a
>> job
>> fails.
>>
>
>

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)
  • SQL Server Angent Mail Profile
    ... >profile named Exchange set up that uses an Exchange ... Outlook is the default mail ... >Exchange profile is the default profile. ... >the current mail client cannot fulfill the messaging ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server agent email profile greyed out
    ... Are you logged locally on the SQL server machine and connected to EM using ... the same domain account with which you set up the outlook profile? ... despite setting the outlook client running as a domain account etc. this ...
    (microsoft.public.sqlserver.server)
  • Re: Application sending email
    ... Top Causes of SQL Server Downtime ... "Is it better to use a mail client that has no ... how can you secure Outlook... ... Package developers want to install Outlook on SQL server (has to ...
    (microsoft.public.sqlserver.security)
  • 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)