• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

Silent install cluster

Hello,

is it possible to do an silent install for a cluster?
If yes, how?

Thanks

bibi
0
bibi92
Asked:
bibi92
1 Solution
 
pg_vinodCommented:
Hope yo are using SQL 2008:

When you perform a command-prompt installation for a failover cluster, you need to have local administrator rights on the server nodes, and the permission to log in as a service and act as part of the operating system. The following example uses the integrated installation method to create the first node of a SQL Server cluster instance and the SQL Server 2008 failover cluster instance itself. The specific action that is selected is InstallFailoverCluster.
setup.exe /q /ACTION=InstallFailoverCluster
/FEATURES=SQL
/INSTANCENAME="CAESAR"
/INSTANCEID="CAESAR"
/INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" /SQLSVCACCOUNT="ROME01\DMNSQLSRV01”
/SQLSVCPASSWORD="XYZ12345"
/AGTSVCACCOUNT="ROME01\ DMNSQLSRVAGT01"
/AGTSVCPASSWORD="XYZ12345"  
/INSTALLSQLDATADIR= "S:\MSSQLSERVER" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /FAILOVERCLUSTERGROUP="CAESAR"
/FAILOVERCLUSTERDISKS="Cluster Disk 3" /FAILOVERCLUSTERIPADDRESSES="IPv4;172.29.10.160;Cluster Network 1;255.255.248.0"
/FAILOVERCLUSTERNETWORKNAME="SQL" /SQLSYSADMINACCOUNTS="ROME01\Administrator"
/SECURITYMODE=SQL
/SAPWD="Yukon900"
/INSTALLSHAREDWOWDIR="C:\Program Files\Microsoft SQL Server"


Note that the previous example was illustrative, and requires modification for your specific environment.

The “/q” switch in the previous example directs setup to operate in an unattended mode (no user interface). After the single-node SQL Server 2008 failover cluster instance is installed, you can then add additional nodes by using the ACTION type of AddNode.
setup.exe /q /ACTION=AddNode /INSTANCENAME="CAESAR" /SQLSVCACCOUNT="ROME01\DMNSQLSRV01" /SQLSVCPASSWORD="XYZ12345" /AGTSVCACCOUNT="ROME0 1\DMNSQLSRVAGT01" /AGTSVCPASSWORD="XYZ12345"
Notice that, when adding a node in the previous example, it required far fewer parameters than when having to add a new SQL Server 2008 failover cluster instance by using the InstallFailoverCluster action. You should execute the AddNode action for each server cluster node that you want to make available for the SQL Server failover cluster to fail over to. For example, if you have a four-node failover cluster, after executing an InstallFailoverCluster action, you would execute an AddNode action unattended installation for each of the other three nodes.
In a similar way to adding a node, removing a node requires very few parameters.
setup.exe /q /ACTION=RemoveNode /INSTANCENAME="CAESAR"
To completely uninstall a SQL Server 2008 failover cluster instance, you execute the RemoveNode action for each node where the SQL Server 2008 failover cluster instance was added. For example, for a four-node cluster, you would execute RemoveNode four times, one for each node. After all of the nodes are removed, the SQL Server 2008 failover cluster instance is effectively uninstalled.


HTH,
Vinod Pottekkatt
0
 
bibi92Author Commented:
Thanks bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now