Search This Blog

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.

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.

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: 

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.