Re: SQL Agent - Mail Profile - Outlook

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 17:01:40 -0000

Hi

This is probably Q11 in
http://support.microsoft.com/default.aspx?scid=kb;EN-US;315886,

John

"Rob Meade" <robb.meade@NO-SPAM.kingswoodweb.net> wrote in message
news:_QWyd.6378$Ar5.6287@text.news.blueyonder.co.uk...
> Hi all,
>
> I have experienced a problem over the last few days with an import job
> failing - this is being investigated, but I thought it best to setup a
> mail
> notification to myself for when this happens in the future.
>
> I setup an operator, and then the mail profile for the SQL Agent, I have
> SQL
> Server / Enterprise Manager and Outlook (not exchange) installed on the
> same
> server, when I was testing this I already had Outlook open and it worked
> fine...
>
> In between then and now I had closed Outlook - ever since I set it to use
> Outlook in the mail profile I was unable to open Outlook to check any
> emails - it just reported that it couldn't access the folders (a
> permissions
> error of sorts)...
>
> I removed the mail profile from the SQL Agent and was then able to open it
> again as normal to check my emails - as you can imagine this isn't
> great...
>
> Some things I know - having my email program on my sql server isn't the
> best
> option...I have a new machine here waiting to be configured and then it
> wont
> be - but there is obviously something going on here with permissions and I
> was hoping to be able to sort it out...
>
> Can anyone suggest what the problem might be, and how I can resolve it - I
> doubt I'm the first to encounter it..
>
> Regards
>
> Rob
>
>

Relevant Pages

  • SQL Agent - Mail Profile - Outlook
    ... I setup an operator, and then the mail profile for the SQL Agent, I have SQL ... Server / Enterprise Manager and Outlook installed on the same ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Agent - Mail Profile - Outlook
    ... SQL Agent will have Outlook open, so Outlook has it's files open. ... get your mail off the server. ... > I setup an operator, and then the mail profile for the SQL Agent, I have ...
    (microsoft.public.sqlserver.programming)
  • Re: Starting to HATE Office 2003
    ... Try creating a new mail profile here: ... Milly Staples [MVP - Outlook] ... | system is running Windows 2000 and Office Pro 2003. ... | email program and it is. ...
    (microsoft.public.office.misc)
  • Re: Cant add data files when creating new Profile in Mail Control
    ... new PST file to your mail profile. ... Milly Staples [MVP - Outlook] ... | button to put it in the run box so Windows would open it. ... Assuming you didn't select to remove the install files at the ...
    (microsoft.public.outlook)
  • Re: unable to open default email????
    ... that to set up a new mail profile. ... Milly Staples [MVP - Outlook] ... unsolicited mail sent to my personal account will be deleted without ... Create a new one and configure it to use your current .pst ...
    (microsoft.public.outlook.installation)
Loading