Can I install SQL failover on a single node WSFC cluster?

  • For depressing reasons, I'm installing 2012.

    Don't ask.  For some other reasons I've had to create a single node WSFC cluster (& will add a node later).  I want to install SQL FCI (not standalone) but I'm struggling.  It could be lots of things, group policy, permissions ...  but ...

    Q 1  - is it even possible to do?

     

    Thank you!

     

  • Yes it is possible to install a SQL FCI on a single node WSFC.

    Can you detail what is failing, may give more to go on.

  • As Ant says, this is definitely possible.  The process is the same as installing yhe first SQL node on a multi-server cluster.

    What problems are you getting?

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Thank you guys, I forgot to get back to you.  I had all sorts of stuff going on unrelated to SQL - gpos, permissions, etc. But I appreciate the reply.  When you work on your own you just need a sanity check sometimes that you're not being a complete div.

    🙂

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

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