Any documentation to set up multi instance cluster

I want to set up 3 active and 1 passive on a 4 node cluster and would like
to see an install guide for something like that. Can anyone redirect me to
one ?
Thanks
Use the guide you found for the first instance, then follow the books online
to install the rest of the instances.
Remember each instance will need an IP and dedicated disk(s).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Hassan" <hassan@.hotmail.com> wrote in message
news:eVo9tfnRHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I want to set up 3 active and 1 passive on a 4 node cluster and would like
>to see an install guide for something like that. Can anyone redirect me to
>one ?
> Thanks
>
|||Are you having trouble setting up the cluster or the SQL Server instances?
If you are running N + I, then when you install SQL Server, you only include
two nodes as potential resource owners.
If we designate nodes 1, 2, and 3 as the active nodes and 4 as the passive,
then for instance 1 you would include nodes 1 and 4, for instance 2, nodes 2
and 4, and for instance 3, nodes 3 and 4.
Other than this, the setup for SQL Server is exactly the same as for a
single instanced, 2-node cluster.
Perhaps I am not understanding your question fully.
Here are two references, one for multi-node clusters, and one for SQL Server
failover clustering (the document is for SS2K but applicable for SS2K5; it
also provides a link to SS2K5 related information).
See the Number of Nodes and Failover Plan section:
http://technet2.microsoft.com/WindowsServer/en/library/f41adff5-87df-483e-9edd-8484501d79921033.mspx?mfr=true
SQL Server:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Sincerely,
Anthony Thomas
"Hassan" <hassan@.hotmail.com> wrote in message
news:eVo9tfnRHHA.3948@.TK2MSFTNGP05.phx.gbl...
> I want to set up 3 active and 1 passive on a 4 node cluster and would like
> to see an install guide for something like that. Can anyone redirect me to
> one ?
> Thanks
>

AntiVirus Software for SQL Cluster Servers

Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
software I should use. Any information will be greatly appreciated.
I like TrendMicro, whatever you get - exclude the MSCS and data directories,
if not the entire shared disks at a minimum.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
> Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
> software I should use. Any information will be greatly appreciated.
>
|||I have never used TrendMicro. Should I order a specific version? will it be
aware of the cluster?
Thanks for your help!
Yuhong
"Rodney R. Fournier [MVP]" wrote:

> I like TrendMicro, whatever you get - exclude the MSCS and data directories,
> if not the entire shared disks at a minimum.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
>
>
|||The latest OfficeScan is cluster aware. Don't let the silly name fool you,
it work for both workstations and servers.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:E2E02DA9-F7B3-48C4-9846-7B0835B4A09D@.microsoft.com...[vbcol=seagreen]
>I have never used TrendMicro. Should I order a specific version? will it be
> aware of the cluster?
> Thanks for your help!
> Yuhong
> "Rodney R. Fournier [MVP]" wrote:
|||Great. Thanks so much for your information!
Yuhong
"Rodney R. Fournier [MVP]" wrote:

> The latest OfficeScan is cluster aware. Don't let the silly name fool you,
> it work for both workstations and servers.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:E2E02DA9-F7B3-48C4-9846-7B0835B4A09D@.microsoft.com...
>
>
|||We use McAfee VirusScan on our clusters. It seems to be working fine. As
Rodney mentioned, do exclude the SQL Server files from scan.
Linchi
"Yuhong" wrote:

> Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
> software I should use. Any information will be greatly appreciated.
>
|||Thanks, Linchi! I will look into these products.
"Linchi Shea" wrote:
[vbcol=seagreen]
> We use McAfee VirusScan on our clusters. It seems to be working fine. As
> Rodney mentioned, do exclude the SQL Server files from scan.
> Linchi
> "Yuhong" wrote:
|||In addition, exclude any backup file locations from virus scan, either on
the local box or on a network share. You don't want to see what happens to
a SQL server if an AV program detects a virus in the backup data stream. It
isn't pretty.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
> Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
> software I should use. Any information will be greatly appreciated.
>
|||OK. Thanks!
Do I need to exclude the MSDTC cluster resource drive from the scan also?
"Geoff N. Hiten" wrote:

> In addition, exclude any backup file locations from virus scan, either on
> the local box or on a network share. You don't want to see what happens to
> a SQL server if an AV program detects a virus in the backup data stream. It
> isn't pretty.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:3201F19C-E8CF-4BF1-AEEF-A5BAEB8D80F1@.microsoft.com...
>
|||I would!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:2CA26428-B8A6-47FB-8DEC-F031CB34F449@.microsoft.com...[vbcol=seagreen]
> OK. Thanks!
> Do I need to exclude the MSDTC cluster resource drive from the scan also?
>
> "Geoff N. Hiten" wrote:

Antivirus on a 2003 Cluster

Hi all
I am trying to work out if it is ok to install an antivirus product onto my
Windows 2003 SQL Cluster.
According to Symantec I can:
http://service1.symantec.com/SUPPORT... er=savce_9.0
but Microsoft don't seem too keen on the idea:
http://support.microsoft.com/default...;EN-US;Q250355
Has anyone managed to install antivirus onto a cluster with no problems or
is it best just to leave my servers as they are?
Thanks
Kristi
You can install, just exclude the MSCS directory and where you put your SQL
Data.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Krissi" <krissi@.hotmail.com> wrote in message
news:42636498$1@.quokka.wn.com.au...
> Hi all
> I am trying to work out if it is ok to install an antivirus product onto
> my
> Windows 2003 SQL Cluster.
> According to Symantec I can:
> http://service1.symantec.com/SUPPORT... er=savce_9.0
> but Microsoft don't seem too keen on the idea:
> http://support.microsoft.com/default...;EN-US;Q250355
> Has anyone managed to install antivirus onto a cluster with no problems or
> is it best just to leave my servers as they are?
> Thanks
> Kristi
>
|||Trend Micro with Server Protect have a good solution.
"Krissi" wrote:

> Hi all
> I am trying to work out if it is ok to install an antivirus product onto my
> Windows 2003 SQL Cluster.
> According to Symantec I can:
> http://service1.symantec.com/SUPPORT... er=savce_9.0
> but Microsoft don't seem too keen on the idea:
> http://support.microsoft.com/default...;EN-US;Q250355
> Has anyone managed to install antivirus onto a cluster with no problems or
> is it best just to leave my servers as they are?
> Thanks
> Kristi
>
>
|||Agreed, that is what I recommend and use, but you still need to exclude
directories
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"LUCA MOTTERLE [MCP]" <LUCAMOTTERLEMCP@.discussions.microsoft.com> wrote in
message news:E2242F94-D213-430C-85C4-DF8712B455D3@.microsoft.com...[vbcol=seagreen]
> Trend Micro with Server Protect have a good solution.
> "Krissi" wrote:

Anti Virus Software 0n Cluster

Hi,
We are building a new Win2k Adv, SQL 2000 cluster.
what is the best way to install the anti virus software after the cluster
has been built....do we need to pause the the node, and then install anti
virus software etc...
Cheers Ray
Guess that depends on the software, though they all seem to act the same to
me. Trend, Norton, etc. can be installed live, from the management console
of the product. NO reboot require. Very simple process.
I think the question you need to ask is, what directory(s) should I exclude
from being scanned.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
<Ray> wrote in message news:OPEfPga7EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We are building a new Win2k Adv, SQL 2000 cluster.
> what is the best way to install the anti virus software after the cluster
> has been built....do we need to pause the the node, and then install anti
> virus software etc...
> Cheers Ray
>
|||Make sure that the antivirus program's filters excludes the
o\MSCS directory on the quorum
oall SQL data (mdf, ndf), log (ldf), Errorlog, Fulltext directories
o\MSDTC directory used by MS DTC
See KBs
http://support.microsoft.com/?kbid=250355
http://support.microsoft.com/?kbid=309422
for additional details.
HTH,
Wish you a Very Happy and Properous New Year.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Do not install anti-virus on a cluster host node EVER!
Antivirus Software May Cause Problems with Cluster Services
http://support.microsoft.com/default...b;en-us;250355
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<Ray> wrote in message news:OPEfPga7EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We are building a new Win2k Adv, SQL 2000 cluster.
> what is the best way to install the anti virus software after the cluster
> has been built....do we need to pause the the node, and then install anti
> virus software etc...
> Cheers Ray
>
|||I have not had a problem with TrendMicro ServerProtect 5.58. Exclude lots of
stuff, but it works great ;)
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OcEHjyc7EHA.2124@.TK2MSFTNGP14.phx.gbl...
> Do not install anti-virus on a cluster host node EVER!
> Antivirus Software May Cause Problems with Cluster Services
> http://support.microsoft.com/default...b;en-us;250355
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> <Ray> wrote in message news:OPEfPga7EHA.1404@.TK2MSFTNGP11.phx.gbl...
>
|||Only problem I have actually experienced with anti-virus and SQL is with
tlog backups. We were storing emails in a database and the AV caught a
virus signature inside a transaction log backup file. BAD THINGS then
happened.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:eXKBd%23c7EHA.3820@.TK2MSFTNGP11.phx.gbl...
> I have not had a problem with TrendMicro ServerProtect 5.58. Exclude lots
of[vbcol=seagreen]
> stuff, but it works great ;)
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OcEHjyc7EHA.2124@.TK2MSFTNGP14.phx.gbl...
cluster
>
|||I've read that article. But the corporate IT security often has more say in
whether to install the anti-virus software, though we can control what
files/directories to exclude from the scan. Often, that means all computers
must have anti-virus software installed and up to date. SQL boxes--clustered
or not--are no exception. It would be really bad for a DBA to wake up one
day finding that the SQL box is infected with a SQL Slammer like virus
because he told the management not to install any anti-virus software there.
Fortunately, we've not had any problem with running anti-virus on cluster
nodes so far.
Linchi
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OcEHjyc7EHA.2124@.TK2MSFTNGP14.phx.gbl...
> Do not install anti-virus on a cluster host node EVER!
> Antivirus Software May Cause Problems with Cluster Services
> http://support.microsoft.com/default...b;en-us;250355
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> <Ray> wrote in message news:OPEfPga7EHA.1404@.TK2MSFTNGP11.phx.gbl...
>
|||"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:OQBprUj7EHA.2180@.TK2MSFTNGP12.phx.gbl...
> I've read that article. But the corporate IT security often has more say
in
> whether to install the anti-virus software, though we can control what
> files/directories to exclude from the scan. Often, that means all
computers
> must have anti-virus software installed and up to date. SQL
boxes--clustered
> or not--are no exception. It would be really bad for a DBA to wake up one
> day finding that the SQL box is infected with a SQL Slammer like virus
> because he told the management not to install any anti-virus software
there.
Not in my opinion.
It would be really bad for the DBA to wake up one day finding that the SQL
box is infected with a SQL Slammer like virus because he didn't apply the
patches that had been available for months previous.
Note that AV software is almost always purely reactionary. It generally
needs a virus signature, which means the virus has to have been in the wild
previously.
In addition, I'm not sure any AV software would catch a virus like Slammer
that's memory resident and runs basically within the scope of an existing
application. (technically it was a worm in any case.)
So, in case you can't tell, I'm not a huge fan of AV software on SQL
Servers. :-
[vbcol=seagreen]
> Fortunately, we've not had any problem with running anti-virus on cluster
> nodes so far.
> Linchi
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OcEHjyc7EHA.2124@.TK2MSFTNGP14.phx.gbl...
cluster
>
|||I have 'ownership' of the entire SQL boxes for our web site operations. I
also have significant influence on the internal operations group. No AV on
clusters and massive exclusions on SQL Servers is the rule around here. Of
course, all our servers are in heavily defended subnets that have to go
through firewalls to get to the outside world. Our network guys are pretty
good at protecting our systems.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:OQBprUj7EHA.2180@.TK2MSFTNGP12.phx.gbl...
> I've read that article. But the corporate IT security often has more say
in
> whether to install the anti-virus software, though we can control what
> files/directories to exclude from the scan. Often, that means all
computers
> must have anti-virus software installed and up to date. SQL
boxes--clustered
> or not--are no exception. It would be really bad for a DBA to wake up one
> day finding that the SQL box is infected with a SQL Slammer like virus
> because he told the management not to install any anti-virus software
there.[vbcol=seagreen]
> Fortunately, we've not had any problem with running anti-virus on cluster
> nodes so far.
> Linchi
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OcEHjyc7EHA.2124@.TK2MSFTNGP14.phx.gbl...
cluster
>

Anti virus on a failover cluster

Are there any cluster aware anti virus products that dont cause problems
such as the ones outlined in KB250355
http://support.microsoft.com/default.aspx/kb/250355 ? I dont want to run
with no anti virus. Thanks
AV products use filter drivers that intercept traffic on the server. You do
not want this on a DBMS server because of the performance overhead
associated with it.
What you can do is use the scheduled file scanning tools that come with most
AV software, but you should disable any ACTIVE SCANNING functionality.
More importantly, DBMS systems should be highly protected by proper
perimeter defenses, VLAN ACLs, and IPSec policies. Short of the necessary
management functions, the only traffic should be the DBMS TCP/IP
communication.
As such, there should be no publicly available network shares. Any email
usage should be strictly outbound SMTP.
The server should be locked down from any Anonymous access.
Therefore, there should be little need for AV software at all on a properly
configured host. Periodic file level scans should be sufficient to properly
protect the system.
Sincerely,
Anthony Thomas
"Enghps1" <jamesserjeant@.blueyonder.co.uk> wrote in message
news:%23HXMOa%23CHHA.572@.TK2MSFTNGP03.phx.gbl...
> Are there any cluster aware anti virus products that dont cause problems
> such as the ones outlined in KB250355
> http://support.microsoft.com/default.aspx/kb/250355 ? I dont want to run
> with no anti virus. Thanks
>
|||Today every machine should have anti virus software, its foolish not to.
Just exclude the DB, logs, and MSCS directories from your scanner. If you
have MSDTC installed, exclude that folder too.
Rodney R. Fournier
MVP - Windows Server - Clustering
Internally Caffeinated MCT
Windows 2000/2003 MCSE: Security/Messaging
MCSA 2000/2003: Security/Messaging
MCSE + Internet (NT 4.0), MCSE 3.5
HP/Compaq AIS-ASE, CTT+, MSS, LCP
A+, Network+, Server+, i-Net+, Security+
And Great Guy
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Enghps1" <jamesserjeant@.blueyonder.co.uk> wrote in message
news:%23HXMOa%23CHHA.572@.TK2MSFTNGP03.phx.gbl...
> Are there any cluster aware anti virus products that dont cause problems
> such as the ones outlined in KB250355
> http://support.microsoft.com/default.aspx/kb/250355 ? I dont want to run
> with no anti virus. Thanks
>