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
>
2012年2月16日星期四
2012年2月13日星期一
Any comments on DCPROMO to promote domain controller on SQL Server?
We're planning to make our SQL server act as a passive domain controller
and are considering the use of DCPromo to accomplish this. Anybody have
comments regarding their experience changing the Domain Controller roles
on an active SQL server? We've all seen problems in the past monkeying
with core components on stable systems...
Thanks in advance.It is generally not recommende to put SQL on a domain controller ( because
of potential security issues and the DC is likely busy anyway.)
however, the thing that comes to mind is that when the box gets promoted to
a DC, the Domain Controller Security policy now applies to the machine in
addition to the local policies...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Rusty" <aid940one@.nospam.ohwhocares.com> wrote in message
news:40193732.7020809@.nospam.ohwhocares.com...
and are considering the use of DCPromo to accomplish this. Anybody have
comments regarding their experience changing the Domain Controller roles
on an active SQL server? We've all seen problems in the past monkeying
with core components on stable systems...
Thanks in advance.It is generally not recommende to put SQL on a domain controller ( because
of potential security issues and the DC is likely busy anyway.)
however, the thing that comes to mind is that when the box gets promoted to
a DC, the Domain Controller Security policy now applies to the machine in
addition to the local policies...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Rusty" <aid940one@.nospam.ohwhocares.com> wrote in message
news:40193732.7020809@.nospam.ohwhocares.com...
quote:
> We're planning to make our SQL server act as a passive domain controller
> and are considering the use of DCPromo to accomplish this. Anybody have
> comments regarding their experience changing the Domain Controller roles
> on an active SQL server? We've all seen problems in the past monkeying
> with core components on stable systems...
> Thanks in advance.
>
标签:
accomplish,
act,
considering,
controller,
controllerand,
database,
dcpromo,
domain,
microsoft,
mysql,
oracle,
passive,
planning,
promote,
server,
sql
Any comments on DCPROMO to promote domain controller on SQL Server?
We're planning to make our SQL server act as a passive domain controller
and are considering the use of DCPromo to accomplish this. Anybody have
comments regarding their experience changing the Domain Controller roles
on an active SQL server? We've all seen problems in the past monkeying
with core components on stable systems...
Thanks in advance.It is generally not recommende to put SQL on a domain controller ( because
of potential security issues and the DC is likely busy anyway.)
however, the thing that comes to mind is that when the box gets promoted to
a DC, the Domain Controller Security policy now applies to the machine in
addition to the local policies...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Rusty" <aid940one@.nospam.ohwhocares.com> wrote in message
news:40193732.7020809@.nospam.ohwhocares.com...
> We're planning to make our SQL server act as a passive domain controller
> and are considering the use of DCPromo to accomplish this. Anybody have
> comments regarding their experience changing the Domain Controller roles
> on an active SQL server? We've all seen problems in the past monkeying
> with core components on stable systems...
> Thanks in advance.
>
and are considering the use of DCPromo to accomplish this. Anybody have
comments regarding their experience changing the Domain Controller roles
on an active SQL server? We've all seen problems in the past monkeying
with core components on stable systems...
Thanks in advance.It is generally not recommende to put SQL on a domain controller ( because
of potential security issues and the DC is likely busy anyway.)
however, the thing that comes to mind is that when the box gets promoted to
a DC, the Domain Controller Security policy now applies to the machine in
addition to the local policies...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Rusty" <aid940one@.nospam.ohwhocares.com> wrote in message
news:40193732.7020809@.nospam.ohwhocares.com...
> We're planning to make our SQL server act as a passive domain controller
> and are considering the use of DCPromo to accomplish this. Anybody have
> comments regarding their experience changing the Domain Controller roles
> on an active SQL server? We've all seen problems in the past monkeying
> with core components on stable systems...
> Thanks in advance.
>
订阅:
博文 (Atom)