Orphaned Sessions and locks: mail

Showing posts with label mail. Show all posts

Friday, March 30, 2012

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 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

Wednesday, March 28, 2012

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

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/default.aspx?scid=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/default.aspx?scid=kb;en-us;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...
> Hi
> No. Only full Outlook.
> http://support.microsoft.com/default.aspx?scid=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
>>|||"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

Outlook Client on SQL Cluster

Hi,
We currently have a two node sql cluster running SQL Mail.
At present we have to manually start up outlook so the mail client works.
I have been looking at the resource options and wondered if it was possible to setup outlook client as a resource and if so, what reg keys would I need to tell the resource to access?
Cheers
Adam
Hi Adam,
If I get your question right, you are wondering if you could make Outlook client as a cluster resource.
Answer is Yes. I am not well aware of what Outlook clients need( like regkeys e.t.c.). But say if you want to make a simple application like Notepad.exe or Cmd.exe you could host them as cluster resources by making a resource of type "Generic Application".
Here is a little more on Generic Application resouce type: http://msdn.microsoft.com/library/de...pplication.asp
If this does not help then you might need to write a Resource dll that could make the interact with the OutLook client.
More on creating new Resource Types: http://msdn.microsoft.com/library/de...urce_types.asp
Thanks,
Sandeep Sutari
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights. Use of any included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
"Adam Maltby" <adamm@.frfl.co.uk> wrote in message news:enSXGsoLEHA.3324@.TK2MSFTNGP10.phx.gbl...
Hi,
We currently have a two node sql cluster running SQL Mail.
At present we have to manually start up outlook so the mail client works.
I have been looking at the resource options and wondered if it was possible to setup outlook client as a resource and if so, what reg keys would I need to tell the resource to access?
Cheers
Adam
|||Thanks for your response..... I got it working (in a fashion)...
My problem now is that although outlook will start and receive email as a cluster resource, sql email cannot access it, reason being it is now a cluster service it has to start using cluster services credentials, not the logged in user credentials....
Does anyone know of any way round that?
Cheers
Adam
|||MSCS doesn't support SQL Mail properly...
Try to use non-clustering server instead.
sql

Outlook 2003 with SQL2000

Hi,
Is anyone using Outlook 2003 as the mail client with SQL2000 on either W2K
or W2K3? Please let me know if this combination is being used?
Thanks
Chris Wood
Alberta Department of Energy
CANADAHaving the same problem here.|||LW,
Are you having problems trying to use Outlook 2003 client for SQL Mail on
the SQL Server?
I just want to know if this is a valid combination.
Chris
"LW" <anonymous@.discussions.microsoft.com> wrote in message
news:7BD31EC5-16B0-47B5-8FBA-2B9E0C09C261@.microsoft.com...
> Having the same problem here.

Outlook 2003 with SQL2000

Outlook 2003 Issue

The problem I have it appears that mail gets stuck in the Outbox while
Outlook is closed. When I leave it open (Outlook) it does not appear to be a
problem.
I cannot leave Outlook open and a Server Terminal open (in a locked
workstation state) as it is againist corporation policy.
"Yih-Yoon Lee" wrote:

> It should work. Are you having any problem?
> Yih-Yoon Lee
> Betty [User] wrote:
>
The spooling in Outlook was changed in 2002 and I'd suspect
it's the same in 2003. Use Outlook 2000. If that's not
doable or if you are getting sick of Outlook and MAPI issues
like these, you can use an alternative to SQL Mail. You can
use just plain old SMTP for mail. Less headache and easier
to maintain. You can download an extended stored procedure
that will do SMTP mail and get more information from:
http://www.sqldev.net/xp/xpsmtp.htm
You can also find some more information on this at:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
-Sue
On Wed, 19 Jan 2005 09:31:04 -0800, Betty [User]
<bettyuser@.noemail.mail2.com> wrote:
[vbcol=seagreen]
>The problem I have it appears that mail gets stuck in the Outbox while
>Outlook is closed. When I leave it open (Outlook) it does not appear to be a
>problem.
>I cannot leave Outlook open and a Server Terminal open (in a locked
>workstation state) as it is againist corporation policy.
>"Yih-Yoon Lee" wrote:
|||All,
Thank you for your replies, Yih-Yoon and Sue. I will consider the options
available (Outlook 2000/98 or SMTP Mail).
Thank you once again for your assistance,
Betty/
sql

Outlook 2003 does not work with SQL Mail !

It would appear that Outlook 2003 (and 2002) does not work with SQL Mail,
unless you are using an Exchange Server. The SQL Mail program and Outlook
2003 *BOTH* try to open the Personal Folder file (.pst file) and one of them
fails.
If I close the Outlook 2003 client, SQL Mail works fine, except that the
mail does not go out! The mail only goes out when the Outlook client is
running and since the .pst file is locked, it only runs when SQL Mail is
disabled!
So I can't generate email alerts in SQL unless I close down Outlook and I
can't get those alerts to go out unless I disable SQL Mail. What a crappy
setup! ... or am I missing something?No you are not. That is the way it is. If you want trouble free SQL Mail
with Outlook you must use Outlook 2000. Otherwise you will run into Access
denied erros in the MAPI subsystem. That is because SQL Mail does not
release MAPI. You have to shut down the SQL Server Service. Fire up
Outlook then restart the SQL Service but as soon as SQL Mail acts once you
will be right back to the MAPI access deniied errors.
--
George Hester
_________________________________
"fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
news:6866961B-7F29-443E-B6D3-132E20B66E95@.microsoft.com...
> It would appear that Outlook 2003 (and 2002) does not work with SQL Mail,
> unless you are using an Exchange Server. The SQL Mail program and Outlook
> 2003 *BOTH* try to open the Personal Folder file (.pst file) and one of
them
> fails.
> If I close the Outlook 2003 client, SQL Mail works fine, except that the
> mail does not go out! The mail only goes out when the Outlook client is
> running and since the .pst file is locked, it only runs when SQL Mail is
> disabled!
> So I can't generate email alerts in SQL unless I close down Outlook and I
> can't get those alerts to go out unless I disable SQL Mail. What a crappy
> setup! ... or am I missing something?
>|||Actually there is a workaround for this issue. Let me know if you want to
hear how it is done and I can explain it to you.
--
George Hester
_________________________________
"fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
news:6866961B-7F29-443E-B6D3-132E20B66E95@.microsoft.com...
> It would appear that Outlook 2003 (and 2002) does not work with SQL Mail,
> unless you are using an Exchange Server. The SQL Mail program and Outlook
> 2003 *BOTH* try to open the Personal Folder file (.pst file) and one of
them
> fails.
> If I close the Outlook 2003 client, SQL Mail works fine, except that the
> mail does not go out! The mail only goes out when the Outlook client is
> running and since the .pst file is locked, it only runs when SQL Mail is
> disabled!
> So I can't generate email alerts in SQL unless I close down Outlook and I
> can't get those alerts to go out unless I disable SQL Mail. What a crappy
> setup! ... or am I missing something?
>|||Yes, let me know what the workaround is!
Fred
"George Hester" wrote:
> Actually there is a workaround for this issue. Let me know if you want to
> hear how it is done and I can explain it to you.
> --
> George Hester
> _________________________________
> "fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
> news:6866961B-7F29-443E-B6D3-132E20B66E95@.microsoft.com...
> > It would appear that Outlook 2003 (and 2002) does not work with SQL Mail,
> > unless you are using an Exchange Server. The SQL Mail program and Outlook
> > 2003 *BOTH* try to open the Personal Folder file (.pst file) and one of
> them
> > fails.
> >
> > If I close the Outlook 2003 client, SQL Mail works fine, except that the
> > mail does not go out! The mail only goes out when the Outlook client is
> > running and since the .pst file is locked, it only runs when SQL Mail is
> > disabled!
> >
> > So I can't generate email alerts in SQL unless I close down Outlook and I
> > can't get those alerts to go out unless I disable SQL Mail. What a crappy
> > setup! ... or am I missing something?
> >
> >
>|||OK. What you do is set 2 Profiles in Microsoft Outlook. You will get your
eMail in one profile and the other will receive your SQL Alerts. The SQL
Mail holds on to the MAPI service. This is the reason for the error. So if
you start Outlook with your SQL Mail profile before SQL Mail starts then
start SQL Mail you will get your alerts. You can then close Outlook and go
back into your eMail Profile. But you cannot reopen Outlook with the SQL
Mail profile while SQL Mail is using that profile, running. You have to
stop SQL Mail then go into the SQL Mail Profile with Outlook then restart
SQL Mail.
--
George Hester
_________________________________
"fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
news:30265F89-8F2B-4296-8CDA-C577B9AEE5E7@.microsoft.com...
> Yes, let me know what the workaround is!
>
> Fred
> "George Hester" wrote:
> > Actually there is a workaround for this issue. Let me know if you want
to
> > hear how it is done and I can explain it to you.
> >
> > --
> >
> > George Hester
> > _________________________________
> > "fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
> > news:6866961B-7F29-443E-B6D3-132E20B66E95@.microsoft.com...
> > > It would appear that Outlook 2003 (and 2002) does not work with SQL
Mail,
> > > unless you are using an Exchange Server. The SQL Mail program and
Outlook
> > > 2003 *BOTH* try to open the Personal Folder file (.pst file) and one
of
> > them
> > > fails.
> > >
> > > If I close the Outlook 2003 client, SQL Mail works fine, except that
the
> > > mail does not go out! The mail only goes out when the Outlook client
is
> > > running and since the .pst file is locked, it only runs when SQL Mail
is
> > > disabled!
> > >
> > > So I can't generate email alerts in SQL unless I close down Outlook
and I
> > > can't get those alerts to go out unless I disable SQL Mail. What a
crappy
> > > setup! ... or am I missing something?
> > >
> > >
> >
> >|||Sorry George, you lost me there. The problem I have with Outlook 2003 and SQL
alerts is that the SQL alerts are generated, but don't go out unless Outlook
is running.
I am not sure how having two mail profiles will help. I have tried setting
up an Outlook email profile (say OutlookMail) and a SQL email profile (say
SQLMail). If I then set up SQL Alerts to use the SQLMail profile and launch
Outlook using the OutlooMail profile, everything works, *except* that the
alerts are generated, but don't go out!
Just having Outlook running (with the OutlookMail profile) does not seem to
help the SQL alerts. They are not going out, because the SQLMail profile's
mailbox (.pst file) is not being processed, only the OutlookMail mailbox is.
Did I miss something? I even tried setting up the OutlookMail profile in
Outlook to read and process the SQLMail profile's mail file, but that did not
work either.
Help !!
"George Hester" wrote:
> OK. What you do is set 2 Profiles in Microsoft Outlook. You will get your
> eMail in one profile and the other will receive your SQL Alerts. The SQL
> Mail holds on to the MAPI service. This is the reason for the error. So if
> you start Outlook with your SQL Mail profile before SQL Mail starts then
> start SQL Mail you will get your alerts. You can then close Outlook and go
> back into your eMail Profile. But you cannot reopen Outlook with the SQL
> Mail profile while SQL Mail is using that profile, running. You have to
> stop SQL Mail then go into the SQL Mail Profile with Outlook then restart
> SQL Mail.
> --
> George Hester
> _________________________________
> "fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
> news:30265F89-8F2B-4296-8CDA-C577B9AEE5E7@.microsoft.com...
> > Yes, let me know what the workaround is!
> >
> >
> > Fred
> >
> > "George Hester" wrote:
> >
> > > Actually there is a workaround for this issue. Let me know if you want
> to
> > > hear how it is done and I can explain it to you.
> > >
> > > --
> > >
> > > George Hester
> > > _________________________________
> > > "fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
> > > news:6866961B-7F29-443E-B6D3-132E20B66E95@.microsoft.com...
> > > > It would appear that Outlook 2003 (and 2002) does not work with SQL
> Mail,
> > > > unless you are using an Exchange Server. The SQL Mail program and
> Outlook
> > > > 2003 *BOTH* try to open the Personal Folder file (.pst file) and one
> of
> > > them
> > > > fails.
> > > >
> > > > If I close the Outlook 2003 client, SQL Mail works fine, except that
> the
> > > > mail does not go out! The mail only goes out when the Outlook client
> is
> > > > running and since the .pst file is locked, it only runs when SQL Mail
> is
> > > > disabled!
> > > >
> > > > So I can't generate email alerts in SQL unless I close down Outlook
> and I
> > > > can't get those alerts to go out unless I disable SQL Mail. What a
> crappy
> > > > setup! ... or am I missing something?
> > > >
> > > >
> > >
> > >
>

Friday, March 30, 2012

Outloook 2002 & SQL Server 2000

Outlook Mail on Cluster

Outlook locked when using sql 2005 - please help

Outlook locked when using sql 2005 - please help

Outlook locked when using sql 2005

Wednesday, March 28, 2012

Outlook locked when using sql 2005

Outlook licensing on SQL Server

Outlook licensing on SQL Server

Outlook licensing on SQL Server

outlook express with SQL server 2000

outlook express with SQL server 2000

outlook express with SQL server 2000

Outlook Client on SQL Cluster

Outlook 2003 with SQL2000

Outlook 2003 with SQL2000

Outlook 2003 Issue

Outlook 2003 does not work with SQL Mail !

Outlook 2003 does not work with SQL Mail !

Outlook 2003 does not work with SQL Mail !

Orphaned Sessions and locks

Blog Archive

About Me