 | |
Re: SQL Server & Active Directory Domain Controller on same cluster no
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: SQL Server & Active Directory Domain Controller on same cluster no -
07-19-2004
, 03:58 PM
|
The link http://www.microsoft.com/technet/pro.../failclus.mspx tells the following: Cluster Nodes and Windows Domains All nodes in the cluster must be members of the same domain and able to access a domain controller and a Domain Name System (DNS) server, as well as |
you are going to install SQL Server, as you may encounter some problems,
including the fact that domain controller functionality (such as Active
Directory) is not cluster aware, so all information will be local. This
impacts things such as a directory enabled program's ability to publish
under the virtual server's computer object, which does not work in a
cluster. A WINS server is still required for Windows 2000/SQL Server 2000 in
a clustered environment if name resolution of virtual resource is required.
Quote:
|
Question: Does "dcpromo" work on an MSCSed cluster? or Does MSCS installation fail on a PDC/BDC? or Does it error out when installing the SQL |
DCPROMO works, but is usually not needed on a clustered node. Most don't run
applications on Domain Controllers. Exchange 2033 for example is not even
supported on a Clustered DC.
MSCS will work on a DC (PDC/BDC is not 4.0, please don't go there). Again,
but why? Keep the DC's separate, with two they will be Highly Available.
SQL Server 2000 will install and run on a 2000/2003 DC clustered node. But,
again if care about SQL, DON'T DO THIS.
#2
| |||
| |||
|
|
The link http://www.microsoft.com/technet/pro.../failclus.mspx tells the following: Cluster Nodes and Windows Domains All nodes in the cluster must be members of the same domain and able to access a domain controller and a Domain Name System (DNS) server, as well as a WINS server. The nodes should not be configured as domain controllers if you are going to install SQL Server, as you may encounter some problems, including the fact that domain controller functionality (such as Active Directory) is not cluster aware, so all information will be local. This impacts things such as a directory enabled program's ability to publish under the virtual server's computer object, which does not work in a cluster. A WINS server is still required for Windows 2000/SQL Server 2000 in a clustered environment if name resolution of virtual resource is required. Question: Does "dcpromo" work on an MSCSed cluster? or Does MSCS installation fail on a PDC/BDC? or Does it error out when installing the SQL server on a node with Active Directory & MSCS installed? |
#3
| |||
| |||
|
|
If it is recommended, does Microsoft support such configuration, if there are problems for troubleshooting? "Sarma Pisapati" wrote: The link http://www.microsoft.com/technet/pro.../failclus.mspx tells the following: Cluster Nodes and Windows Domains All nodes in the cluster must be members of the same domain and able to access a domain controller and a Domain Name System (DNS) server, as well as |
you are going to install SQL Server, as you may encounter some problems,
including the fact that domain controller functionality (such as Active
Directory) is not cluster aware, so all information will be local. This
impacts things such as a directory enabled program's ability to publish
under the virtual server's computer object, which does not work in a
cluster. A WINS server is still required for Windows 2000/SQL Server 2000 in
a clustered environment if name resolution of virtual resource is required.
Quote:
|
Question: Does "dcpromo" work on an MSCSed cluster? or Does MSCS installation fail on a PDC/BDC? or Does it error out when installing the SQL |
#4
| |||
| |||
|
|
Rod, Thanks. We are a consolidation company with Unisys ES7000s (32 processor systems) [grin]. We look to consolidate without sacrificing security and integrity. |
Quote:
|
"Rodney R. Fournier [MVP]" wrote: Yes they support it (unless you are running Exchange 2003 on the DC Clustered node). But again, I really don't see the need since the standard DC configuration is robust enough without adding clustering. Sure, cluster SQL, great idea. Just leave the DCs on standard machines. Just my two cents... Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering "Sarma Pisapati" <SarmaPisapati (AT) discussions (DOT) microsoft.com> wrote in message news:21B722E4-3C55-41AE-9CCA-84B4E167BB46 (AT) microsoft (DOT) com... If it is recommended, does Microsoft support such configuration, if there are problems for troubleshooting? "Sarma Pisapati" wrote: The link http://www.microsoft.com/technet/pro.../failclus.mspx tells the following: Cluster Nodes and Windows Domains All nodes in the cluster must be members of the same domain and able to access a domain controller and a Domain Name System (DNS) server, as well as a WINS server. The nodes should not be configured as domain controllers if you are going to install SQL Server, as you may encounter some problems, including the fact that domain controller functionality (such as Active Directory) is not cluster aware, so all information will be local. This impacts things such as a directory enabled program's ability to publish under the virtual server's computer object, which does not work in a cluster. A WINS server is still required for Windows 2000/SQL Server 2000 in a clustered environment if name resolution of virtual resource is required. Question: Does "dcpromo" work on an MSCSed cluster? or Does MSCS installation fail on a PDC/BDC? or Does it error out when installing the SQL server on a node with Active Directory & MSCS installed? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.