Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |