1

I am trying to install SQL Server 2016 failover clustered instance on a Windows Server 2016 workgroup cluster. I have tried using a virtual account and also a local account that exists on both nodes.

Both types of account throw the error:

The specified Service Account is not valid. Please provide a domain account to continue

What type of account should I use for installing SQL Server 2016 failover clustered instance on a Windows Server 2016 workgroup cluster?

2

It turns out that only Availability Groups are supported on workgroup clusters in 2016. SQL FCI is not supported. You must use a domain.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.