Tuesday, October 19, 2010

SQL Server 2008 Cluster configuration on Virtual Server 2005

Today I finished SQL Server 2008 Cluster installation on Virtual Server 2005.
It was not difficult in the end but, I encountered with lots of changes in the configuration as compared to SQL Server 2005. Couple of new things have been added in SQL Server 2008 clustering configuration including clustering setup, Shared drive configuration etc...

The environment I used is as follows.
1. Virtual Server 2005 SP1
2. 3 Virtual machines of Windows 2008 running on it.
3. SQL Server 2008
4. ISCSI Drives using StarWind.

Steps I followed.
1. Create a Parent Virtual Machine.
2. Make that machine to work as a Domain controller
3. Create 2 Clone machine of DC to work as Cluster Nodes.
4. Create a Private/Public network between all 3 machines.
5. Add other 2 machine in the Domain.
6. Create ISCSI Drives which can be used as shared drive in the configuration.
7. Configure Machine1 as a Failover cluster Node1 with ISCSI Drive.
8. Configure Machine2 as a Failover Cluster Node2 With ISCSI Drive.
9. Configure MSDTC Service in the cluster setup.
10. Install SQL Server 2008 as Cluster on Node1.
11. Add Node2 in the cluster configuration.

In the end it was good learning for me, will be sharing the details as how to configure soon!!

No comments:

Post a Comment