SQLTeam.com | Weblogs | Forums

AlwaysOn on SQLSERVER 2016 Developer Edition Error

On Below environment I am getting this error "An error occurred while loading the AlwaysOn High Availability properties [return code: 0x80070005]. What the problem?

select @@VERSION
Microsoft SQL Server 2016 (SP1-CU8) (KB4077064) - 13.0.4474.0 (X64) Feb 24 2018 13:53:17
Copyright (c) Microsoft Corporation Developer Edition (64-bit)on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

I thought this was part of install, you had to specifically install it. I don't remember though, but you can throw the disk in and run through to see

Is the cluster already configured? I still don't think you should get that error though.

Having just had this exact same issue and with no luck using PowerShell either I finally found that adding the NETWORK SERVICE account to the local admin group on the cluster nodes fixed that error. This was on a hardened server that possibly had the permission previously and later removed.