Outlook locked when using sql 2005 - please help

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.Jack wrote:
> 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.
>
Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
using POP3? Do you not have an in-house mail server?|||No, we do not have one.
"Tracy McKibben" wrote:
> Jack wrote:
> > 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.
> >
> Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
> using POP3? Do you not have an in-house mail server?
>|||Jack wrote:
> No, we do not have one.
>
Ok, well, I assume you have access to an SMTP server and can send email
- point DBMail to that server and forget Outlook.

Outlook locked when using sql 2005 - please help

Jack wrote:
> 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 serv
er
> 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.
>
Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
using POP3? Do you not have an in-house mail server?No, we do not have one.
"Tracy McKibben" wrote:

> Jack wrote:
> Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
> using POP3? Do you not have an in-house mail server?
>|||Jack wrote:
> No, we do not have one.
>
Ok, well, I assume you have access to an SMTP server and can send email
- point DBMail to that server and forget Outlook.|||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 jo
b
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.|||Jack wrote:
> 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 serv
er
> 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.
>
Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
using POP3? Do you not have an in-house mail server?|||No, we do not have one.
"Tracy McKibben" wrote:

> Jack wrote:
> Dump Outlook and POP3, use DBMail as provided by SQL 2005. Why are you
> using POP3? Do you not have an in-house mail server?
>|||Jack wrote:
> No, we do not have one.
>
Ok, well, I assume you have access to an SMTP server and can send email
- point DBMail to that server and forget Outlook.

Outlook locked when using sql 2005

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 jo
b
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.Is there any reason why you are not using Database Mail? You would not need
Outlook with Database Mail.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jack" wrote:

> 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 serv
er
> 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.|||Yes, our IT department does not want to go the SMTP route.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Is there any reason why you are not using Database Mail? You would not nee
d
> Outlook with Database Mail.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Jack" wrote:
>|||Is there any reason why you are not using Database Mail? You would not need
Outlook with Database Mail.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jack" wrote:

> 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 serv
er
> 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.|||Yes, our IT department does not want to go the SMTP route.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Is there any reason why you are not using Database Mail? You would not nee
d
> Outlook with Database Mail.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Jack" wrote:
>sql

Outlook locked when using sql 2005

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.Is there any reason why you are not using Database Mail? You would not need
Outlook with Database Mail.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jack" wrote:
> 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.|||Yes, our IT department does not want to go the SMTP route.
"Ben Nevarez" wrote:
> Is there any reason why you are not using Database Mail? You would not need
> Outlook with Database Mail.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Jack" wrote:
> > 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.

Outlook Express

Newbie question - can Outlook Express be used with SQL Server 2000 for
notifications? Or do I have to use Outlook?
Rachael
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!AFAIK it is not supported on 32 bit SQL2000 for SQL Agent mail, however it
does work if you have SQL2000 SP3, the supported route is to use Outlook.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rachael Faber" <rfaber@.alldata.net> wrote in message
news:e0G4tvMUDHA.1712@.TK2MSFTNGP11.phx.gbl...
Newbie question - can Outlook Express be used with SQL Server 2000 for
notifications? Or do I have to use Outlook?
Rachael
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!