Post reply

AlwaysOn on SQLSERVER 2016 Developer Edition Error

  • November 15, 2018 at 4:25 pm

    #368950

    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)


  • November 15, 2018 at 5:00 pm

    #2013756

    databases.specialist - Thursday, November 15, 2018 4:25 PM

    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)


    Try running SQL Server Configuration Manager as Administrator - Run as administrator.
    If that doesn't work you can enable it with Powershell.
    Enable-SqlAlwaysOn -Path SQLSERVER:\SQL\Computer\Instance

    Sue

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

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