Silent install cluster

Posted on 2011-10-18
Last Modified: 2012-05-12

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


Question by:bibi92
    LVL 3

    Accepted Solution

    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
    /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" /SQLSVCACCOUNT="ROME01\DMNSQLSRV01”
    /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.
    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.

    Vinod Pottekkatt

    Author Closing Comment

    Thanks bibi

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now