ProjectSMM.com
Gonzo TechNet
MS SQL 2005 Clustering
Installation and Upgrading Step-By-Step
Step-By-Step directions on how To Install or Upgrade SQL 2005 Clustering on Windows Server 2003
- Configure MS DTC for Network Access
- Install SQL Server Components
- Install Workstation Tools & Utilities on remaining nodes
- Apply Service Packs
- Update Books-Online
- Optionally... Install the SQL Client for SQL 2005 on workstations
Setup Prerequisites:
- Virtual Name of the Windows server/cluster
- Virtual Name of the SQL server/cluster
- IP Address from the MSDTC Network process
- Cluster Resource Group for the MSDTC resources
- Cluster Resource Group for the SQL/Database resources
- Network/Domain Account for SQL Services (SQL Server/Browser/etc.)
- Netowrk/Domain Group for service accounts
Install Note:
If you are installing on a system with multi-core processesors and the number of cores per process is NOT a "power of 2", use the following:
E:\sql\disk1\setup.exe HOTFIXPATCH="E:\SQL\SP3\Ext\hotfixsql\files\sqlrun_sql.msp"
See: KB945835:
On a computer that has a multicore processor, if the ratio of logical processors to physical sockets is not a power of 2, you cannot install SQL Server 2005