Building active/active SQL cluster- Part2

In this session we will continue illustrating how to build an active/active SQL cluster, we built the cluster in the last session, we will install the SQL cluster in this session.

i prefer that you copy the installation source files to the local harddisk, i have experienced some faulty CD and hardware in my work, and it it will cause a lot of time to fix the corrupted installation specially in cluster environment.

so let us begin:

before you start in the SQL cluster installation you have to create a named instance pipe on each node for each named instance you will install, this is a very important  step or the installation will fail.

To create a named pipe fpr the installation follow steps in the following KB:

http://support.microsoft.com/kb/815431

Install SQL in ACTIVW/ACTIVE cluster environment:

- from the SQL installation source double click on setup.exe.

 

- In the Welcome creen, click on SQL server 2000 components

 

- In the install component screen, click on Install database server.

 

- In the welcome screen, click next.

 

- In the licensing screen, enter the administrator name and organization name,Click Next.

 

in the installation option, enter the first virtual server name "DBVS1".

in the fail over clustering page, enter an IP that will be associated with the failover cluster,Click Next.

 

in the cluster disk selection, seelct a disk that SQL data file will be installed on,Click next.

 

in the cluster definition, be sure to select both nodes to be included in the cluster configuration,Click next.

 

In the Remote Information page, enter a valid administrator credentials,Click Next

 

 

in the instance name clear the default instance checn box, be sure to installed a named isntance as we identified in the named pipe before, because there is could be only one default instance on the cluster server.

 enter an instance name i chose (NI1), Click next.

in the setup type, choose custom, click next.

 

In the select components, clear the bookonline, and development tools.

 

in the service account, enter a valid user name and password which the SQL service will runder it's credentials.

 

in the authentication mode, select windows authentication (unless you will run application using SQL authentication), then click next.

 

in the collation setting, click next

 

wait until the setup finish, verify that the SQL cluster installed succesfully. the installation of the second node is typically similar to the first node instalaltion, but you will chose a diiferent virtual server name and different instance name (i chose DBVS2, NI2).

after that designate one server for a SQL virtual server, and designated the other node for the other VS and NI.

have fun