Outloook 2002 & SQL Server 2000

Hi ,
I am running SQL server 2000 sp3a and MS Outlook 2002. I have created the
profile and tested it within mail from the ontrol panel which i can received
the email.
From SQL Server , i assigned the profile "Test" to SQL Mail & SQL Mail Agent
and click on the test which said "Successfully started(stopped) a mail
session with this profile".
Then i went ahead to create the operator and put in a valid email addr and i
click on the "test" which gave me a return message that said "the message wa
s
successfully sent" but somehow i did not recieve that email
How can i fix this ?
appreciate ur advice
tks & rdgs
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1Hi ,
to add on further i used Query Analyzer and i got the "mail sent" using
xp_sendmail @.recipient = 'eee' , @.subject = 'oooo'
tks & rdgs
maxzsim wrote:
>Hi ,
> I am running SQL server 2000 sp3a and MS Outlook 2002. I have created the
>profile and tested it within mail from the ontrol panel which i can receive
d
>the email.
>From SQL Server , i assigned the profile "Test" to SQL Mail & SQL Mail Agen
t
>and click on the test which said "Successfully started(stopped) a mail
>session with this profile".
>Then i went ahead to create the operator and put in a valid email addr and
i
>click on the "test" which gave me a return message that said "the message w
as
>successfully sent" but somehow i did not recieve that email
>How can i fix this ?
>appreciate ur advice
>tks & rdgs
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||Hi ,
Upon further checking i see that all those mails were "stucked" in the MS
Outlook.
I'll have to manually click on the "send/receive" to sent out those emails .
furthermore , i can only send to those company email addr and not the
hotmail/gmail address.
i have set up the SMTP server but not the POP3 server i do not intend to
receive any incoming email
How can i prevent the emails from being saved to MS Outlook and i don't have
to manually click on the "send/receive" and how can i send to all valid emai
l
addresses ?
appreciate ur advice
tks & rdgs
maxzsim wrote:
>Hi ,
> to add on further i used Query Analyzer and i got the "mail sent" using
>xp_sendmail @.recipient = 'eee' , @.subject = 'oooo'
>tks & rdgs
>
>
>[quoted text clipped - 15 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||I am pretty sure you cannot because that is the latest outlook security
feature to prevent software sending out junk emails. Software could be
downloaded and take over your email service to send out emails without you
knowing it.
"maxzsim via webservertalk.com" <u14644@.uwe> wrote in message
news:5c2572e6256ac@.uwe...
> Hi ,
> Upon further checking i see that all those mails were "stucked" in the MS
> Outlook.
> I'll have to manually click on the "send/receive" to sent out those emails
> .
> furthermore , i can only send to those company email addr and not the
> hotmail/gmail address.
> i have set up the SMTP server but not the POP3 server i do not intend to
> receive any incoming email
> How can i prevent the emails from being saved to MS Outlook and i don't
> have
> to manually click on the "send/receive" and how can i send to all valid
> email
> addresses ?
> appreciate ur advice
> tks & rdgs
> maxzsim wrote:
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||Hi ,
I want to configure something with SQL Mail & SQL Agent Mail to auto send
out alert email so what software could help me acheive this ?
tks & rdgs
Grant wrote:
>I am pretty sure you cannot because that is the latest outlook security
>feature to prevent software sending out junk emails. Software could be
>downloaded and take over your email service to send out emails without you
>knowing it.
>
>[quoted text clipped - 29 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1|||Hi ,
Actually i am as to why i ccan only send to company123@..xxx.sss
but not xxx@.hotmail/gmail.com as i thought if you could send via SMTP then i
t
shld send as long as its a valid email addr ?
i got this error message " 554 Relay rejected for policy reasons."
appreciate ur advice
tks & rdgs
Grant wrote:
>I am pretty sure you cannot because that is the latest outlook security
>feature to prevent software sending out junk emails. Software could be
>downloaded and take over your email service to send out emails without you
>knowing it.
>
>[quoted text clipped - 29 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1

outlook web access - weird

I have subscriptions setup to deliver reports in PDF format to users email
address. No problem there. When the email is opened in the Outlook client,
the attachment appears as expected and can be opened. The problem is when
the user accesses their email using Outlook web access (OWA). The email
appears and even has the paper clip identifying the attachment. However,
when the email is opened. the attachment is gone."chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:F54988C0-2987-484D-AE80-F0B50F002E1D@.microsoft.com...
>I have subscriptions setup to deliver reports in PDF format to users email
> address. No problem there. When the email is opened in the Outlook
> client,
> the attachment appears as expected and can be opened. The problem is when
> the user accesses their email using Outlook web access (OWA). The email
> appears and even has the paper clip identifying the attachment. However,
> when the email is opened. the attachment is gone.
Can they open other pdf-files from their OWA?
Any security settings in play?
Did they test their OWA on a machine they knew there was a PDF-reader
installed on?
I know that sometimes I need to download pdf-files on my computer before
opening them in my OWA. But I'm quite sure the link for downloading is there
when I open the message, though.
Kaisa M. Lindahl|||they can open other pdf's through OWA, just not the ones delivered through
reporting services.
"Kaisa M. Lindahl" wrote:
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:F54988C0-2987-484D-AE80-F0B50F002E1D@.microsoft.com...
> >I have subscriptions setup to deliver reports in PDF format to users email
> > address. No problem there. When the email is opened in the Outlook
> > client,
> > the attachment appears as expected and can be opened. The problem is when
> > the user accesses their email using Outlook web access (OWA). The email
> > appears and even has the paper clip identifying the attachment. However,
> > when the email is opened. the attachment is gone.
> Can they open other pdf-files from their OWA?
> Any security settings in play?
> Did they test their OWA on a machine they knew there was a PDF-reader
> installed on?
> I know that sometimes I need to download pdf-files on my computer before
> opening them in my OWA. But I'm quite sure the link for downloading is there
> when I open the message, though.
> Kaisa M. Lindahl
>
>

Outlook vs. cdosysmail SQL 2000

Hello everyone,

I'm trying to get a feeling of which method of setting up e-mail notifcations is more used and why. I'm finding that once Outlook is set up on a server using the e-mail functions are pretty straight forward and flexable. I've also been experimenting with using cdosysmail so I can avoid installing and configuring Outlook, but it's a big more of a work around.

What do you do?

Thanks

Using MAPI on SQL Server 2000 is generally considered a unnecessary risk.

I suggest that you examine using xp_smtpmail instead. Refer to this thread for more information.

Outlook vs Outlook Express on SQL server

I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
Meenal
Meenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default...b;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>
|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default...b;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
sql

Outlook vs Outlook Express on SQL server

I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
> >I wanted to know if there was any difference in having Outlook or Outlook
> > Express installed on the SQL server machine if it is used for parsing
> > emails
> > and for job failure notifications with in the SQL Agent.
> >
> >
> > thanks
> > Meenal
> >
> >
>

Outlook vs Outlook Express on SQL server

I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/defaul...kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/defaul...kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>

Outlook needs to be open for SMTP.

sql2k sp3a
Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
for SQL Alerts. I can get everything running with no problems. I set up an
operator and can test it 10 times in a row with success... while Outlook is
opened. But if I close Outlook, I will be able to test with success no more
than 2 times. (Though it does say sent successfull.) I will hit the test
button and the email will never arrive.
I will then log onto the box and attempt to open Outlook and it won't allow
me too. It complains about the Outlook.pst file being in use. The only way
to free this file up is to restart the SQL Agent. Only then does my test
email possibly arrive.
Has anyone else experienced this? Fix?
TIA, ChrisR
Maybe one of the articles linked here:
http://www.aspfaq.com/2403
(Or you might consider switching to XP_SMTP_SendMail.)
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"ChrisR" <noemail@.bla.com> wrote in message
news:OZ7ldn3PFHA.2348@.tk2msftngp13.phx.gbl...
> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook
> is opened. But if I close Outlook, I will be able to test with success no
> more than 2 times. (Though it does say sent successfull.) I will hit the
> test button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't
> allow me too. It complains about the Outlook.pst file being in use. The
> only way to free this file up is to restart the SQL Agent. Only then does
> my test email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>
|||ChrisR
your not alone, i had the same issue. NEVER found an answer ((HUGS))
"ChrisR" wrote:

> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook is
> opened. But if I close Outlook, I will be able to test with success no more
> than 2 times. (Though it does say sent successfull.) I will hit the test
> button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't allow
> me too. It complains about the Outlook.pst file being in use. The only way
> to free this file up is to restart the SQL Agent. Only then does my test
> email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>

Outlook needs to be open for SMTP.

sql2k sp3a
Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
for SQL Alerts. I can get everything running with no problems. I set up an
operator and can test it 10 times in a row with success... while Outlook is
opened. But if I close Outlook, I will be able to test with success no more
than 2 times. (Though it does say sent successfull.) I will hit the test
button and the email will never arrive.
I will then log onto the box and attempt to open Outlook and it won't allow
me too. It complains about the Outlook.pst file being in use. The only way
to free this file up is to restart the SQL Agent. Only then does my test
email possibly arrive.
Has anyone else experienced this? Fix?
TIA, ChrisRMaybe one of the articles linked here:
http://www.aspfaq.com/2403
(Or you might consider switching to XP_SMTP_SendMail.)
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"ChrisR" <noemail@.bla.com> wrote in message
news:OZ7ldn3PFHA.2348@.tk2msftngp13.phx.gbl...
> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook
> is opened. But if I close Outlook, I will be able to test with success no
> more than 2 times. (Though it does say sent successfull.) I will hit the
> test button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't
> allow me too. It complains about the Outlook.pst file being in use. The
> only way to free this file up is to restart the SQL Agent. Only then does
> my test email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>|||ChrisR
your not alone, i had the same issue. NEVER found an answer ((HUGS))
"ChrisR" wrote:
> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook is
> opened. But if I close Outlook, I will be able to test with success no more
> than 2 times. (Though it does say sent successfull.) I will hit the test
> button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't allow
> me too. It complains about the Outlook.pst file being in use. The only way
> to free this file up is to restart the SQL Agent. Only then does my test
> email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>

Outlook needs to be open for SMTP.

sql2k sp3a
Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
for SQL Alerts. I can get everything running with no problems. I set up an
operator and can test it 10 times in a row with success... while Outlook is
opened. But if I close Outlook, I will be able to test with success no more
than 2 times. (Though it does say sent successfull.) I will hit the test
button and the email will never arrive.
I will then log onto the box and attempt to open Outlook and it won't allow
me too. It complains about the Outlook.pst file being in use. The only way
to free this file up is to restart the SQL Agent. Only then does my test
email possibly arrive.
Has anyone else experienced this? Fix?
TIA, ChrisRMaybe one of the articles linked here:
http://www.aspfaq.com/2403
(Or you might consider switching to XP_SMTP_SendMail.)
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"ChrisR" <noemail@.bla.com> wrote in message
news:OZ7ldn3PFHA.2348@.tk2msftngp13.phx.gbl...
> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook
> is opened. But if I close Outlook, I will be able to test with success no
> more than 2 times. (Though it does say sent successfull.) I will hit the
> test button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't
> allow me too. It complains about the Outlook.pst file being in use. The
> only way to free this file up is to restart the SQL Agent. Only then does
> my test email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>|||ChrisR
your not alone, i had the same issue. NEVER found an answer ((HUGS))
"ChrisR" wrote:

> sql2k sp3a
> Ive been testing using the Pop3/ SMTP option as an alternative to Exchange
> for SQL Alerts. I can get everything running with no problems. I set up an
> operator and can test it 10 times in a row with success... while Outlook i
s
> opened. But if I close Outlook, I will be able to test with success no mor
e
> than 2 times. (Though it does say sent successfull.) I will hit the test
> button and the email will never arrive.
> I will then log onto the box and attempt to open Outlook and it won't allo
w
> me too. It complains about the Outlook.pst file being in use. The only way
> to free this file up is to restart the SQL Agent. Only then does my test
> email possibly arrive.
> Has anyone else experienced this? Fix?
> TIA, ChrisR
>
>sql

OUTLOOK message into SQL database

Hi Everybody,
I'm doing a program to generate newsletter and in turn need to read the boun
ced email message from OUTLOOK and store these data into SQL db. These bounc
ed email addresses will need to be collected and for further processing.
But different ISP has different format of presenting their bounced email for
mat, eg. some will included the bounced email address in the subject, some i
n the content and some as attachment. Has anyone done this before, extractin
g specified information from OUTLOOK message and update into SQL db?
Would appreciate if somebody can show me some light.
Thanks in advance.
KristeI didnt directly used Outlook, i used Exchange server to get my message fro
m the folder
and put it in the SQL Server DB. Would beinteresting if you also have the ch
ance to get to your inbox on a Exchange server or via IMAP or if you only ha
ve the change to get the information from a pop3 pop or just outlook.
If you were sending out the information from the Account SQL Server is using
for sending E-Mails the XP
xp_readmail would be a choice for you. It reads the inbox messages of the ac
coutn of SQL Server (Agent).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Kriste L" <whiteegg@.hotmail.com> schrieb im Newsbeitrag news:uKLxqxUUFHA.28
92@.TK2MSFTNGP14.phx.gbl...
Hi Everybody,
I'm doing a program to generate newsletter and in turn need to read the boun
ced email message from OUTLOOK and store these data into SQL db. These bounc
ed email addresses will need to be collected and for further processing.
But different ISP has different format of presenting their bounced email for
mat, eg. some will included the bounced email address in the subject, some i
n the content and some as attachment. Has anyone done this before, extractin
g specified information from OUTLOOK message and update into SQL db?
Would appreciate if somebody can show me some light.
Thanks in advance.
Kriste

Outlook Mail on Cluster

Hi All
I have Sql2k virtual Server running in Active passive mode on Win2k3
Cluster.
Now my question is how do i configure the Outlook client on those nodes, is
it just a straight install on both the nodes and then confiture it with Sql
Virtual server?
Can i make the Oulook client to be a cluster resource
thanks in advance
Outlook is not cluster aware. You can create identical Outlook profiles on
all cluster nodes but any messages 'in process' during a cluster failover
will be lost. Outlook is also not a service so there can be some stability
issues as well. I prefer using xp_smtp from www.sqldev.net. It is not a
drop-in replacement for SQL Mail, but it can be adapted or extended to cover
most of your needs. I use it on a cluster and it is extremely stable.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Nik" <sqlserverkb@.yahoo.com> wrote in message
news:uT$Ro692EHA.1144@.TK2MSFTNGP09.phx.gbl...
> Hi All
> I have Sql2k virtual Server running in Active passive mode on Win2k3
> Cluster.
> Now my question is how do i configure the Outlook client on those nodes,
is
> it just a straight install on both the nodes and then confiture it with
Sql
> Virtual server?
> Can i make the Oulook client to be a cluster resource
> thanks in advance
>
|||Hi Nik,
In addition to the great advice/comments that Geoff had, I wanted to add
that SQL Mail is not supported on a cluster.
http://support.microsoft.com/default...B;EN-US;298723
BUG: SQL Mail Not Fully Supported for Use in Conjunction with Cluster
Virtual SQL Servers (298723)
Thanks!
Donna Lambert
Microsoft PSS
SQL Server Support
|||not supported, but works to some degree... well, thats what i am hearing
from others.
"Donna Lambert [MS]" <dlambert@.online.microsoft.com> wrote in message
news:ke4CL9rGFHA.1140@.TK2MSFTNGXA02.phx.gbl...
> Hi Nik,
> In addition to the great advice/comments that Geoff had, I wanted to add
> that SQL Mail is not supported on a cluster.
> http://support.microsoft.com/default...B;EN-US;298723
> BUG: SQL Mail Not Fully Supported for Use in Conjunction with Cluster
> Virtual SQL Servers (298723)
> Thanks!
> Donna Lambert
> Microsoft PSS
> SQL Server Support
>

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 licensing on SQL Server

Hi
Just a quick question, if I use outlook as the MAPI client for the SQL
server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
license for the copy of Outlook I will use on the server even though we wll
not actually be using Outlook on that server as a full client?
I forgot to ask if it also means that we need a, Exhange CAL for the SQL
server as Outlook will be communicating with our Exchange server
"OGTI" wrote:

> Hi
> Just a quick question, if I use outlook as the MAPI client for the SQL
> server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
> license for the copy of Outlook I will use on the server even though we wll
> not actually be using Outlook on that server as a full client?
|||Hi.
You need the appropriate Office license and an Exchange CAL.
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/
"OGTI" <OGTI@.discussions.microsoft.com> wrote in message
news:66B8929F-3E51-4CBD-8707-D03834C372DE@.microsoft.com...[vbcol=seagreen]
>I forgot to ask if it also means that we need a, Exhange CAL for the SQL
> server as Outlook will be communicating with our Exchange server
> "OGTI" wrote:

Outlook licensing on SQL Server

Hi
Just a quick question, if I use outlook as the MAPI client for the SQL
server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
license for the copy of Outlook I will use on the server even though we wll
not actually be using Outlook on that server as a full client?I forgot to ask if it also means that we need a, Exhange CAL for the SQL
server as Outlook will be communicating with our Exchange server
"OGTI" wrote:
> Hi
> Just a quick question, if I use outlook as the MAPI client for the SQL
> server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
> license for the copy of Outlook I will use on the server even though we wll
> not actually be using Outlook on that server as a full client?|||Hi.
You need the appropriate Office license and an Exchange CAL.
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/
"OGTI" <OGTI@.discussions.microsoft.com> wrote in message
news:66B8929F-3E51-4CBD-8707-D03834C372DE@.microsoft.com...
>I forgot to ask if it also means that we need a, Exhange CAL for the SQL
> server as Outlook will be communicating with our Exchange server
> "OGTI" wrote:
>> Hi
>> Just a quick question, if I use outlook as the MAPI client for the SQL
>> server agent and SQL Mail section of SQL Server 2000 do I need to
>> purchase a
>> license for the copy of Outlook I will use on the server even though we
>> wll
>> not actually be using Outlook on that server as a full client?

Outlook licensing on SQL Server

Hi
Just a quick question, if I use outlook as the MAPI client for the SQL
server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
license for the copy of Outlook I will use on the server even though we wll
not actually be using Outlook on that server as a full client?I forgot to ask if it also means that we need a, Exhange CAL for the SQL
server as Outlook will be communicating with our Exchange server
"OGTI" wrote:

> Hi
> Just a quick question, if I use outlook as the MAPI client for the SQL
> server agent and SQL Mail section of SQL Server 2000 do I need to purchase
a
> license for the copy of Outlook I will use on the server even though we wl
l
> not actually be using Outlook on that server as a full client?|||Hi.
You need the appropriate Office license and an Exchange CAL.
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/
"OGTI" <OGTI@.discussions.microsoft.com> wrote in message
news:66B8929F-3E51-4CBD-8707-D03834C372DE@.microsoft.com...[vbcol=seagreen]
>I forgot to ask if it also means that we need a, Exhange CAL for the SQL
> server as Outlook will be communicating with our Exchange server
> "OGTI" wrote:
>

outlook express with SQL server 2000

Hi ,
Can i know if outlook express is able to work with SQL server 2000 ?
i have created a acct but sql mail not able to find that profile
tks & rdgs
Hi
No. Only full Outlook.
http://support.microsoft.com/default...b;en-us;263556
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"maxzsim" wrote:

> Hi ,
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
> tks & rdgs
>
|||Just as a follow up to Mikes answer:
http://support.microsoft.com/default...311231&sd=tech
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:6A471B90-25E4-4FAE-80EB-BCE1C997B3FA@.microsoft.com...[vbcol=seagreen]
> Hi
> No. Only full Outlook.
> http://support.microsoft.com/default...b;en-us;263556
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "maxzsim" wrote:
|||"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:7D00E3BD-B7D7-405A-B891-FE823F4BBB93@.microsoft.com...
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
AFAIK you must install and configure Outlook (not Express) to get SQLMail
running.
Regards, Wojtek
sql

outlook express with SQL server 2000

Hi ,
Can i know if outlook express is able to work with SQL server 2000 ?
i have created a acct but sql mail not able to find that profile
tks & rdgsHi
No. Only full Outlook.
http://support.microsoft.com/defaul...kb;en-us;263556
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"maxzsim" wrote:

> Hi ,
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
> tks & rdgs
>|||Just as a follow up to Mikes answer:
http://support.microsoft.com/defaul...;311231&sd=tech
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:6A471B90-25E4-4FAE-80EB-BCE1C997B3FA@.microsoft.com...[vbcol=seagreen]
> Hi
> No. Only full Outlook.
> http://support.microsoft.com/defaul...kb;en-us;263556
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "maxzsim" wrote:
>|||"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:7D00E3BD-B7D7-405A-B891-FE823F4BBB93@.microsoft.com...
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
AFAIK you must install and configure Outlook (not Express) to get SQLMail
running.
Regards, Wojtek