Re: SQL Agent - Mail Profile - Outlook

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 17:58:09 +0100

Hi

SQL Agent will have Outlook open, so Outlook has it's files open. So you
can't access it too.

As you said, get your mail off the server. Hope you have AV on the server if
you are reading mails there.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"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

  • Re: SQL Agent - Mail Profile - Outlook
    ... > I setup an operator, and then the mail profile for the SQL Agent, I have ... > In between then and now I had closed Outlook - ever since I set it to use ... > I removed the mail profile from the SQL Agent and was then able to open it ... > Some things I know - having my email program on my sql server isn't the ...
    (microsoft.public.sqlserver.programming)
  • Re: Outlook2003 email crashes with junkmail
    ... Try recreating your mail profile; ... This is especially true when you did an upgrade or install on a machine that ... Also Outlook FAQ, How To's, Downloads and more... ... > to the server was interrupted. ...
    (microsoft.public.outlook)
  • Re: Keeping mail on server
    ... Recreate your mail profile; Control Panel-> Mail-> button Show Profiles... ... Microsoft Office and Microsoft Office related News ... Also Outlook FAQ, How To's, Downloads and more... ... > of my mail on the server. ...
    (microsoft.public.outlook.general)
  • 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: Error 22022: Problems with email
    ... I have decided to wait until the email server is upgraded to Exchange 2003, ... make sure your SQL Agent account and SQL Server start-up account are ... Try to create a new mail profile associating to SQL Agent Mail and try ...
    (microsoft.public.sqlserver.server)