Creating AG read only node for cluster

  • THought I had this right but here is where I am stuck.

    Built active passive 2014 Ent Edition Cluster which seems to be fine.

    Added a stand alone server to the cluster (windows cluster) which will house read only ag node.

    In this new node (lets call it an01) i tried to install sql server and during setup I get an error that Standalone server on WFC cluster can not have shared storage (it has it's own disk subsytem to house RO database.

    AM I missing a step or did I fumble something?

  • tcronin 95651 (4/14/2016)


    THought I had this right but here is where I am stuck.

    Built active passive 2014 Ent Edition Cluster which seems to be fine.

    Added a stand alone server to the cluster (windows cluster) which will house read only ag node.

    In this new node (lets call it an01) i tried to install sql server and during setup I get an error that Standalone server on WFC cluster can not have shared storage (it has it's own disk subsytem to house RO database.

    AM I missing a step or did I fumble something?

    The new server has local storage and the sql server paths to be used have been set to match what the failover cluster instance is using on the other 2 nodes, is that correct?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Are you installing the SQL as a standalone instance, or as a failover cluster secondary node? The error sounds like the latter, but you should be doing the former.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply