Configuring SQLServer2005 clusters in VMware Step by Step (v) SQL Server cluster installation

installation SQLServer2005 cluster 1. Install MSDTC, open Control Panel, add removal program, add delete Windows components, select Application Server, select Enable Network DTC Access

2. Add resource MSDTC to cluster manager after Setup completes

3. Select all nodes to

4. Select MSDTC dependencies, resources include disk Q (quorum disk) and cluster name

5. In cluster management, after selecting MSDTC, click Right to go online

6. Install SQL Server, select Disk1 to install

7. Click Next

8. Next Step

9. After system configuration check is complete, run next

10. Enter the relevant serial number

11. Select SQL Server Database Services and create a SQL Server failover cluster

12. To name an instance, in this case sqlclustertest

13. Enter virtual server name and instance name consistent

14. Enter SQL Server virtual service ip:192.168.0.211

15. Select group 0 or sharedisk disk for database installation

16. Select Available Nodes

17. Enter the remote account password

18. Service account set to use domain account

19. Configure domain groups for the Cluster service

20. Configure authentication mode for Windows Authentication mode

21. Set up Database sorting rules

22. Select Install

! BPtFl6517 23. Select Next

24. Click Finish

25. The Cluster service information for SQL Server can be seen in Cluster Administrator group 0

26. MSSQLServer menus are available on the boot menu of NodeA and NodeB

27. Run Disk2 Setup, install SQL Server Management tools, etc.

28. Select Next to install

29. Run mssms in SQL Server on the Startup menu

30. After landing, you can do SQL Server related operations.