Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Specify SQL Server Installation location when Adding second node to Cluster Expand / Collapse
Author
Message
Posted Friday, June 6, 2014 1:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:17 PM
Points: 184, Visits: 1,012
When adding a node to a SQL Server 2012 Standard edition cluster, how I do I identify the location for SQL server shared components and the rest of the SQL Server installation binaries?

When adding a node to a SQL Server 2012 Standard edition cluster all the binaries went to the C: drive default location. We put those files on a different drive when installing the first node. What needs to be done so both nodes have the binaries on the same drives and folders?



David Bird

My PC Quick Reference Guide
Post #1578488
Posted Saturday, June 7, 2014 2:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:26 PM
Points: 38, Visits: 557
Hello,

If you're adding node to existing SQL Server 2012 cluster it will perform an installation that is identical to your first node, including any directories you have defined. Pretty much only thing you can choose is the clustered instance you wish to add the second node to and then type in the passwords for your Service Accounts when prompted.





Mika Sutinen, Senior DBA
@SQLFinn on Twitter
Blogging at SQLStarters
Post #1578600
Posted Tuesday, June 10, 2014 1:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:17 PM
Points: 184, Visits: 1,012
Something went wrong with my install because the DTEXEC is located on different drives on each node.

David Bird

My PC Quick Reference Guide
Post #1579397
Posted Monday, June 16, 2014 2:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:55 AM
Points: 2,868, Visits: 3,214
Put it another way... On an ADDNODE install you cannot specify the location for the SQL binaries, they always go to the system drive.

I agree it is a good idea to have the binaries on the same drive letters on all nodes, so it is the original primary node you need to fix. My advice is:
a) Fail over to your newly added second node
b) Evict the old first node from the cluster
c) Reinstall Windows on the old primary node
d) Install SQL Server in a configuration to match the other nodes in the cluster

In theory it is possible to uninstall SQL Server on the old primary node and thus avoid the Windows rebuild, but personally I always regard a SQL install as a one-way process because I want the environment it runs in to be as clean as possible.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1581022
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse