In this demo I'll show you how to cluster SQL 2005 in a Windows 2008 R2 RC build.
In the demo I'll show you how to solve most of the common errors during setup process:
"The Virtual Server name you provided is not valid. To proceed, provide a virtual server name".
"You do not have privileges to add accounts to the domain groups specified for this failover cluster. Ask your domain administrator for privileges to add new accounts to the domain groups, or log on using an account that does have permission."
We'll also check how to cluster MSDTC in Windows 2008 R2 and configure the Firewall to allow Transactions.
Check how easy is to cluster SQL 2005 in Windows 2008 R2.
Note: The video doesn't show the configuration for SQL ports. To configure the firewall please check the following links:
Configuring the Windows Firewall to Allow SQL Server Access
For multi-homed SQL servers check:
How to Configure a Multi-Homed Computer for SQL Server Access