GAPTHEGURU

Geek with special skills

Script for adding the second node on a SQL 2008 failover cluster

    1. Start Command Prompt as administrator
    2. Navigate to the SQL install path
    3. Change the following parameters in the command line:
      <servername>= Servername/instance to the server
      <account> =       Serviceaccount for the SQL instance
      <password>=      Serviceaccount for the serveraccount.

setup.exe /ACTION=AddNode /INSTANCENAME=”MSSQLSERVER”
/SQLSVCACCOUNT=”<Domain\Account>” /SQLSVCPASSWORD=”<Password>”
/AGTSVCACCOUNT=”<Domain/Account>”, /AGTSVCPASSWORD=”<Password>” /ASSVCACCOUNT=”<Account/Password>” /ASSVCPASSWORD=”<Password>” /INDICATEPROGRESS

Advertisements

11/29/2011 - Posted by | Sql Server

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: