Outlook locked with sql 2005

22 Jun 2006 6:32 PM

Jack

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
email operator and defined notifications on a job to send out emails when job
completes.

The issue is the my outlook client on the server gets locked once sql server
agent is started and no emails get sent out when the job is executed.

I get the message - Unable to open your default email folders.....when
opening outlook.

It is outlook 2003, we are using POP as email and sql is 2005 standard.

The email notifications are only sent out when I stop the sql server agent,
open outlook, close it and then start sql server agent again.

25 Jun 2006 10:45 AM

Tibor Karaszi

I have a feeling that this has more to do with Outlook than SQL Server. I've tried Outlook 2002 and
2003 with little luck. The Outlook that has worked best for me is 2000. However, I haven't done any
MAPI SQL Mail for a while since I use either xpsmtp or Database Mail.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Jack" <J***@discussions.microsoft.com> wrote in message
news:0C708525-3E15-4ACD-9010-3FD38AD5050E@microsoft.com...
>I am setting up SQL 2005 server. We are using SQL Mail. I have defined the
> email operator and defined notifications on a job to send out emails when job
> completes.
>
> The issue is the my outlook client on the server gets locked once sql server
> agent is started and no emails get sent out when the job is executed.
>
> I get the message - Unable to open your default email folders.....when
> opening outlook.
>
> It is outlook 2003, we are using POP as email and sql is 2005 standard.
>
> The email notifications are only sent out when I stop the sql server agent,
> open outlook, close it and then start sql server agent again.
>