Re: SQL Server Agent Mail Profile
From: Lyle (someone_at_iowavet.com)
Date: 09/24/04
- Next message: Scott: "RE: Bulk Copy / BCP problem....please advise"
- Previous message: Shaun Stuart: "Re: .ASP, MTS transactions, and stored procedure I/O variables"
- In reply to: John Bell: "Re: SQL Server Agent Mail Profile"
- Next in thread: John Bell: "Re: SQL Server Agent Mail Profile"
- Reply: John Bell: "Re: SQL Server Agent Mail Profile"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 16:04:14 -0500
Hi John,
Both are running as the same account that has the email profile. Any
other ideas?
Thanks,
Lyle
"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:%23ERrESnoEHA.4008@TK2MSFTNGP14.phx.gbl...
> Hi
>
> You will need to run your Sql Server service and SQL Agent Service as an
> account that has the mail profile. See
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
>
> John
>
> "Lyle" <anonymous@discussions.microsoft.com> wrote in message
> news:128301c4a263$59d2b660$7d02280a@phx.gbl...
> > 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 recieve 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. 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?
>
>
- Next message: Scott: "RE: Bulk Copy / BCP problem....please advise"
- Previous message: Shaun Stuart: "Re: .ASP, MTS transactions, and stored procedure I/O variables"
- In reply to: John Bell: "Re: SQL Server Agent Mail Profile"
- Next in thread: John Bell: "Re: SQL Server Agent Mail Profile"
- Reply: John Bell: "Re: SQL Server Agent Mail Profile"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|