Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
farrokhp
Starting Member
15 Posts |
 Posted - 2011-03-01 : 03:49:29
|
| New to Cluster installation, so let's say for 2 nodes A/P sql2005 installation, we will have a one virtual IP address and 2 Physical IP address...first stupid question: do we install sql 2 times or only one time? second should I login/connect to one of the physical nodes and start the installation or should I login on virtual IP? Where should I copy the SQL CDs? in one of the nodes or both? I am a bit confuse because in Cluster we have one data source but 2 sql installation? right or am I wrong? third: there are plenty of online document but I need a brief one to show the actual steps not like MS documents 100 pages and confusing, please if you know send the link as well. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-01 : 11:01:45
|
| Have a look at this document which has step by step directions, including screen shots of each step. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-03-01 : 16:01:04
|
| Actually, you will have at least 4 IP Addresses and names. And probably a 5th address for MSDTC.ClusterName - IP Address (virtual name for cluster)Node1 - IP Address for physical node 1Node2 - IP Address for physical node 2SQLName - Virtual IP Address for SQL ServerMSDTC - Virtual IP address for MSDTCWhen installing the cluster, you cannot log into the VIP until after you have installed SQL Server. You log into node 1 and make sure nobody is logged into node2 (if someone is RDP'd into that node, the install could fail).After the installation, log into node2 and install the non cluster aware components (e.g. Client Tools, SSIS, SSRS, etc...).Then, apply the service packs from node1 - and again, when complete log into node2 and apply the service pack to the non cluster aware components.I always put the installation media in the same root folder on both nodes - and not on a cluster resource (e.g. local drive like the C drive)Jeff |
|
|
|
|
|
|
|
|
sql 2005 cluster