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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 sql 2005 cluster

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.
Go to Top of Page

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 1
Node2 - IP Address for physical node 2
SQLName - Virtual IP Address for SQL Server
MSDTC - Virtual IP address for MSDTC

When 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
Go to Top of Page
   

- Advertisement -