MS SQL Server 2005 - failover cluster Installation
Please read prerequisites for MS SQL Server 2005 failover cluster installation by clicking here before you proceed further.
SQL Server 2005 Enterprise Edition setup
17. Domain Groups
Cluster Only
When installing SQL on a cluster, the groups required for the SQL installation need to be created in Active Directory and entered manually during the installation.
You can use the same AD group for all the services of a SQL instance or specifiy indvidual group for each service.
Enter the group name for :
SQL Server:
SQL Server Agent:
Congratulations! SQL Server 2005 failover cluster setup is complete.
Following video illustrates Cluster Group resource creation in order to setup MS SQL Server 2005:
Following video illustrates MS SQL Server 2005 Installation on a two node cluster:
For step by step instructions read through the information below.
SQL Server 2005 Enterprise Edition setup
1. Insert the SQL Server 2005 installation CD:
SQL Server setup will autorun. If setup doesn’t start, double click the autorun file in the root of the SQL Server CD
2. Open File Security Warning
Click Run
3. End User License
Select “I accept the licensing…”, Click Next
4. Installing Prerequisites
Depending on what is already installed, you could also see ‘.NET Framework 2.0’.
Click Install
Click Next
5. System Check
6.Welcome Screen
Click Next
7. System Check - Success
Click Next
8. Installation
Cluster installation
For a cluster versus a standalone installation, you have to check the ‘Create a SQL Server failover cluster’ and Click Next
9. Advance - Feature Selection
Click Next
10. Instance Name - select 'Default Instance'
Click Next
11. Cluster Only
Virtual Server Name
Enter the Virtual SQL Server name:
Click Next
12. Enter IP address:
Click Add & Click Next
13. Cluster Only - Group Selection
Select the group used for this SQL installation:
Enter in ‘Data Files’ only the drive letter: *** (ex: E:\)
14. Node Configuration
Select all the nodes that will be owner of the SQL instance.
Click Add, to move them under ‘Selected nodes’.
Click Next
15. Cluster Only - Remote Account
The account listed is the account you used to log on to the server.
Enter the password: ***
Click Next
16. Service account
Enter the information required for the service(s)
Username:
Password:
Domain:
Click Next
17. Domain Groups
Standalone Only
When installing SQL on a standalone server, the groups required for the SQL installation, will be automatically created locally by the SQL installation program i.e. there is nothing to do here for a standalone installation.
When installing SQL on a cluster, the groups required for the SQL installation need to be created in Active Directory and entered manually during the installation.
You can use the same AD group for all the services of a SQL instance or specifiy indvidual group for each service.
Enter the group name for :
SQL Server:
SQL Server Agent:
Full-Text Search:
Click Next
18. Authentication mode
Choose Windows Authentication or Mixed
Click Next
19. Collation Settings
Click Next
20. Usage Report
Click Next
21. Ready to Install
Click Install
AND...NOW... PLEASE BE PATIENT - A LOT OF PATIENCE.
Finish!
Open cluster administrator to verify that SQL was installed in the right cluster group and on the right drive. Resources include: SQL Server, SQL Server Agent, SQL IP Address, SQL Server Fulltext, SQL Network Name, Etc
Congratulations! SQL Server 2005 failover cluster setup is complete.
Read essential steps to be taken post installation of MS SQL Server. Click here for details.
Also check out MS SQL Server 2008 cluster installation guide Click here.