[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Silent install cluster

Posted on 2011-10-18
2
Medium Priority
?
591 Views
Last Modified: 2012-05-12
Hello,

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

Thanks

bibi
0
Comment
Question by:bibi92
2 Comments
 
LVL 3

Accepted Solution

by:
pg_vinod earned 2000 total points
ID: 36987749
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
 

Author Closing Comment

by:bibi92
ID: 36991849
Thanks bibi
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question