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 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 + SQL 2000 SP4 on Windows 2003 2node Active/Passive Cluste

Hi
I have only "heard" that installing Outlook on Windows 2003 cluster running
SQL 2000 might create problems.
Has anyone actually experienced this ? Or am I just hearing rumours.
I would like to install Outlook provided there is no down side to it. What
are the alternatives to Outlook or MAPI all together.
Thanks in advance.Hi
I have not heard of any Outlook/Cluster issue as such but..
it may be the only way of getting Extended MAPI installed on the system
without breaking any licencing agreement or installing exchange server. You
would need to set up exactly the same profile on both side of the cluster.
If you are using a SMTP server (such as excahnge) then you could use XP_SMTP
instead http://www.sqldev.net/xp/xpsmtp.htm
John
"kunalap" wrote:
> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster running
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>|||"kunalap" <kunalap@.discussions.microsoft.com> wrote in message
news:22DB6194-4E10-4D29-A0D6-4C15B5C5D21D@.microsoft.com...
> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster
running
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
>
We have done this. The best advice as others have said is make sure the
profile is exactly the same on both servers.
If you're not connecting to an Exchange server,but say just using SMTP to
SEND message from SQL Server, I'd recommend installing a local SMTP instance
on each node and using that to rely the messages.
Have SQL Mail send to the local copy of the SMTP server. That eliminates a
lot of situations where the MAPI client will hang.
> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>

Outlook + SQL 2000 SP4 on Windows 2003 2node Active/Passive Cluste

Hi
I have only "heard" that installing Outlook on Windows 2003 cluster running
SQL 2000 might create problems.
Has anyone actually experienced this ? Or am I just hearing rumours.
I would like to install Outlook provided there is no down side to it. What
are the alternatives to Outlook or MAPI all together.
Thanks in advance.Hi
I have not heard of any Outlook/Cluster issue as such but..
it may be the only way of getting Extended MAPI installed on the system
without breaking any licencing agreement or installing exchange server. You
would need to set up exactly the same profile on both side of the cluster.
If you are using a SMTP server (such as excahnge) then you could use XP_SMTP
instead http://www.sqldev.net/xp/xpsmtp.htm
John
"kunalap" wrote:

> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster runnin
g
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>|||"kunalap" <kunalap@.discussions.microsoft.com> wrote in message
news:22DB6194-4E10-4D29-A0D6-4C15B5C5D21D@.microsoft.com...
> Hi
> I have only "heard" that installing Outlook on Windows 2003 cluster
running
> SQL 2000 might create problems.
> Has anyone actually experienced this ? Or am I just hearing rumours.
>
We have done this. The best advice as others have said is make sure the
profile is exactly the same on both servers.
If you're not connecting to an Exchange server,but say just using SMTP to
SEND message from SQL Server, I'd recommend installing a local SMTP instance
on each node and using that to rely the messages.
Have SQL Mail send to the local copy of the SMTP server. That eliminates a
lot of situations where the MAPI client will hang.

> I would like to install Outlook provided there is no down side to it. What
> are the alternatives to Outlook or MAPI all together.
> Thanks in advance.
>

Outbound SQL Connections

Hello Everyone,

I have two SQL 2005 clusters, one at a Corporate HQ and another at a hosting site. On each cluster there are several SQL instances each tied to a seperate Cluster Group meaning that there is a virtual cluster IP address assigned to the cluster group which should translate to the instance.

The issue that I am seeing is that in the connection manager, the IP addresses aren't listed correctly and there is sometimes just junk in there -- up to 10 IP addresses listed. There are many replication and service broker jobs running between the clusters all tied to specific IP addresses and ports which map to NAT and ACLs on the firewalls.

Here is the crux of it: While I can change the listening port and IP in the connection manager, how to I ensure that the outbound replication traffic is coming from the right source? If I add the correct IP address into the connection manager for the instance and disable the others, will it send from that IP address?

I have inherited this system and we are making the first strides into intagling this mess, but I am trying to surgically fix this rather than opening up all kinds of security holes in the interim.

Suggestions?

Ryan

Moving to Availability folder.

Outbound SQL Connections

Hello Everyone,

I have two SQL 2005 clusters, one at a Corporate HQ and another at a hosting site. On each cluster there are several SQL instances each tied to a seperate Cluster Group meaning that there is a virtual cluster IP address assigned to the cluster group which should translate to the instance.

The issue that I am seeing is that in the connection manager, the IP addresses aren't listed correctly and there is sometimes just junk in there -- up to 10 IP addresses listed. There are many replication and service broker jobs running between the clusters all tied to specific IP addresses and ports which map to NAT and ACLs on the firewalls.

Here is the crux of it: While I can change the listening port and IP in the connection manager, how to I ensure that the outbound replication traffic is coming from the right source? If I add the correct IP address into the connection manager for the instance and disable the others, will it send from that IP address?

I have inherited this system and we are making the first strides into intagling this mess, but I am trying to surgically fix this rather than opening up all kinds of security holes in the interim.

Suggestions?

Ryan

Moving to Availability folder.

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?
I would first analyze the sql server for bottlenecks. Most of the problems
can be attributed to bad design, poor i/o design , indexing. Have all these
been checked?
Jim
"Daniel" <softwareengineer98037@.yahoo.com> wrote in message
news:%235$vpBwyHHA.3916@.TK2MSFTNGP02.phx.gbl...
> Our high end SQL server cluster is maxed out, how else to expand? Will it
> help to move tables off of the cluster onto other clusters or will that
> just create processing bottleneck on the cluster running SQL server?
>

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Daniel,
This is a question for the .clustering group, so I added it to the list of
groups. Hope you get answer there.
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/
"Daniel" <softwareengineer98037@.yahoo.com> wrote in message
news:OJBAfBwyHHA.3848@.TK2MSFTNGP03.phx.gbl...
> Our high end SQL server cluster is maxed out, how else to expand? Will it
> help to move tables off of the cluster onto other clusters or will that
> just create processing bottleneck on the cluster running SQL server?
>
You can do a node-swap, where you replace each node with a more powerful
one. However, I find chasing performance with hardware is a losing battle.
Find out what resource is maxed out and why. Fix the underlying problem by
rewriting or re-architecting the resource hogs. I usually start a project
like this with a complete assessment and analysis of the existing system so
I can identify likely fixes and present a prioritized list to the client.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:%23f7V971yHHA.5980@.TK2MSFTNGP04.phx.gbl...
> Daniel,
> This is a question for the .clustering group, so I added it to the list of
> groups. Hope you get answer there.
> --
> Dejan Sarka
> http://blogs.solidq.com/EN/dsarka/
> "Daniel" <softwareengineer98037@.yahoo.com> wrote in message
> news:OJBAfBwyHHA.3848@.TK2MSFTNGP03.phx.gbl...
>
sql

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?Can you define "maxed out"? And what are the actual symptoms?
--
Aaron Bertrand
SQL Server MVP
"Daniel" <softwareengineer98037@.yahoo.com> wrote in message
news:eHiAoBwyHHA.3536@.TK2MSFTNGP06.phx.gbl...
> Our high end SQL server cluster is maxed out, how else to expand? Will it
> help to move tables off of the cluster onto other clusters or will that
> just create processing bottleneck on the cluster running SQL server?
>|||On Fri, 20 Jul 2007 12:01:39 -0700, "Daniel"
<softwareengineer98037@.yahoo.com> wrote:
>Our high end SQL server cluster is maxed out, how else to expand? Will it
>help to move tables off of the cluster onto other clusters or will that just
>create processing bottleneck on the cluster running SQL server?
Please don't post the same question to multiple groups. If you must
send one to two groups, but BOTH groups on the SAME copy so that
replies are seen in both places. (It helps if you use the Subject for
a short Subject too.)
I'm no cluster expert, but when the experts get here they will have
some questions. You might want to have answers ready.
What is maxing out? Disk space? CPU utilization? Memory? The
network?
What does high-end mean in this instance? How many servers, how many
and what type processors, how muchy memory, what sort of disk system?
What is the structure of the cluster? How many machines, running what
operating system/version, running what SQL Server
version(s)/instances? What is the failover arrangement?
Generally the smallest unit of SQL Server that can be moved without
re-writing something is a database. Tables fall within databases. A
question about moving tables sounds like you are a system
administrator but not a DBA. With a high-end cluster that is maxing
out you need the hands-on attention of a DBA.
Roy Harvey
Beacon Falls, CT

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?
Please provide additional details about your SQL cluster (hardware, SQL
server version, configuration, etc.) and what constitutes "maxed out". Where
is the bottleneck -- memory, disk, cpu, network? Performance monitor can
help narrow this down.
Also, moving tables off of one cluster to another may make sense under
certain circumstances but it requires knowing the data and how it is accessed
in the very least to be able to give any informative advice. SQL Server 2005
provides some nice functionality along this line.
"Daniel" wrote:

> Our high end SQL server cluster is maxed out, how else to expand? Will it
> help to move tables off of the cluster onto other clusters or will that just
> create processing bottleneck on the cluster running SQL server?
>
>

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?
I'll have to agree. When the speakers sit around in the lounge at a big
conference we trade war stories about clients that have had literally tons
of hardware made unnecessary by some judicious tuning of the database or the
queries. In one case the customer (a BIG company) had not bothered to add
indexes to the tables. They were able to eliminate over half of their
servers. They saved a bunch of money on electricity and the salary of the
kid that designed the database.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"JPD" <nospam@.nospamplease.com> wrote in message
news:Ovf3gapzHHA.3536@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> Hi Daniel,
> What do you mean by maxed out. Is it "maxed out" on I/O, memory, CPU? Run
> a trace in Performance Monitor using the following counters and once
> you've identified the bottlenecks act accordingly, i.e. add more memory or
> more/faster disks or RAID, fix application problems (if you're getting
> blocking situations), remove other apps on the server etc. etc. But before
> you take action you need inform yourself on what the problem really is.
>
> a. LogicalDisk (All Counters and All Instances)
> b. Memory (All Counters)
> c. Paging File (All Counters and All Instances)
> d. PhysicalDisk (All Counters and All Instances)
> e. Processor (All Counters and All Instances)
> f. SQLServer:Access Methods (All Counters)
> g. SQLServer:Buffer Manager (All Counters)
> h. SQLServer:Buffer Node (All Counters and All Instances)
> i. SQLServer:Buffer Partition (All Counters and All Instances)
> j. SQLServer:Databases (All Counters and All Instances)
> k. SQLServer:General Statistics (All Counters)
> l. SQLServer:General Latches (All Counters)
> m. SQLServer:General Locks (All Counters and All Instances)
> n. SQLServer:General Memory Manager (All Counters)
> o. SQLServer:General Plan Cache (All Counters and All Instances)
> p. SQLServer:General Transactions (All Counters)
> q. SQLServer:General Wait Statistics (All Counters and All Instances)
> r. Thread (All Counters and All Instances)
>
> Jonathan
>
> Daniel wrote:

Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?
Can you define "maxed out"? And what are the actual symptoms?
Aaron Bertrand
SQL Server MVP
"Daniel" <softwareengineer98037@.yahoo.com> wrote in message
news:eHiAoBwyHHA.3536@.TK2MSFTNGP06.phx.gbl...
> Our high end SQL server cluster is maxed out, how else to expand? Will it
> help to move tables off of the cluster onto other clusters or will that
> just create processing bottleneck on the cluster running SQL server?
>
|||On Fri, 20 Jul 2007 12:01:39 -0700, "Daniel"
<softwareengineer98037@.yahoo.com> wrote:

>Our high end SQL server cluster is maxed out, how else to expand? Will it
>help to move tables off of the cluster onto other clusters or will that just
>create processing bottleneck on the cluster running SQL server?
Please don't post the same question to multiple groups. If you must
send one to two groups, but BOTH groups on the SAME copy so that
replies are seen in both places. (It helps if you use the Subject for
a short Subject too.)
I'm no cluster expert, but when the experts get here they will have
some questions. You might want to have answers ready.
What is maxing out? Disk space? CPU utilization? Memory? The
network?
What does high-end mean in this instance? How many servers, how many
and what type processors, how muchy memory, what sort of disk system?
What is the structure of the cluster? How many machines, running what
operating system/version, running what SQL Server
version(s)/instances? What is the failover arrangement?
Generally the smallest unit of SQL Server that can be moved without
re-writing something is a database. Tables fall within databases. A
question about moving tables sounds like you are a system
administrator but not a DBA. With a high-end cluster that is maxing
out you need the hands-on attention of a DBA.
Roy Harvey
Beacon Falls, CT