Installing a SQL Server 2008 R2 Failover Cluster by script

  • Article

Many of you ask me for a script sample to install SQL Server 2008 R2 Cluster. You could find below a sample based on the following BOL:How to: Install SQL Server 2008 R2 from the Command Prompt

Before to begin I invite you to read my previous article: Installation of SQL Server 2008 clusters on Windows 2008 .For failover cluster installations, you must be a local administrator with permissions to login as a service, and to act as part of the operating system on all failover cluster nodes.

Step 1: Configuration file of first node

Create a file called "FailedOverInstallation.ini". Then copy/paste the parameters below with your own values

;SQLSERVER2008 Configuration File
[SQLSERVER2008]
 
INSTANCEID="InstanceName"
ACTION="InstallFailoverCluster"
FEATURES=SQLENGINE,REPLICATION,FULLTEXT
QUIET="True"
INSTANCENAME="InstanceName"
FAILOVERCLUSTERDISKS="DiskRessourceName"
FAILOVERCLUSTERGROUP="SQLServerGroupName"
FAILOVERCLUSTERNETWORKNAME="NetworkName"
INSTALLSQLDATADIR="J:\\ "
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE"
FAILOVERCLUSTERIPADDRESSES="IPv4;AdressIP;Public;255.255.255.0"
SECURITYMODE="SQL"
SAPWD=" ********* "
SQLSYSADMINACCOUNTS="Domaine\YourAdminAccountName"

SQLSVCPASSWORD=" ********* "
AGTSVCPASSWORD=" ********* "
AGTSVCACCOUNT="Domaine\SQLAgentAccountName"
SQLSVCACCOUNT="Domaine\SQLServerAccountName"

 

Step 2: Installation of the first node

Run the following command in the command prompt to call the configuration file on the first node.

C:\installFiles\setup.exe /ConfigurationFile=C:\FailedOverInstallation.ini /IACCEPTSQLSERVERLICENSETERMS

Step 3: Configuration of secondaries nodes (Add Node)

Create a file called "FailedOverInstallation.ini". Then copy/paste the parameters below with your own values

;SQLSERVER2008 Configuration File*
[SQLSERVER2008]
ACTION="AddNode"
QUIET="True"
INSTANCENAME="InstanceName"
FAILOVERCLUSTERGROUP="SQLServerGroupName"
FAILOVERCLUSTERNETWORKNAME="NetworkName"

SQLSVCPASSWORD=" ********* "
AGTSVCPASSWORD=" ********* "
AGTSVCACCOUNT="Domaine\SQLAgentAccountName"
SQLSVCACCOUNT="Domaine\SQLServerAccountName"

Step 4: Installation of the second node
Run the following command in the command prompt to call the configuration file on the second node.

C:\installFiles\setup.exe /ConfigurationFile=C:\AddnodeInstallation.ini /IACCEPTSQLSERVERLICENSETERMS

 

Good installation.

Michel Degremont | Premier Field Engineer - SQL Server Core Engineer |