Not able to perform SCCM Site Reset

Question

Not able to perform SCCM Site Reset Availability groups in SQL is not enable

logs
INFO: Executing SQL Server command: <IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(‘sys.availability_group_listener_ip_addresses’) ) ~ SELECT count(*) FROM sys.availability_group_listener_ip_addresses ~ WHERE ip_address IN(SELECT local_net_address FROM sys.dm_exec_connections WHERE session_id = @@SPID) ~ELSE ~ SELECT 0> $$<Configuration Manager Setup><07-30-2020 11:01:17.799+240><thread=30912 (0x78C0)>
ERROR: Failed to execute query: IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(‘sys.availability_group_listener_ip_addresses’) ) ~ SELECT count(*) FROM sys.availability_group_listener_ip_addresses ~ WHERE ip_address IN(SELECT local_net_address FROM sys.dm_exec_connections WHERE session_id = @@SPID) ~ELSE ~ SELECT 0 $$<Configuration Manager Setup><07-30-2020 11:01:17.799+240><thread=30912 (0x78C0)>
ERROR: Failed to detect whether always on is enabled or not. $$<Configuration Manager Setup><07-30-2020 11:01:17.799+240><thread=30912 (0x78C0)>
ERROR: Could not connect to the SQL Server XXXXXX to determine if the server is always on, or failed to run the query. $$<Configuration Manager Setup><07-30-2020 11:01:17.815+240><thread=30912 (0x78C0)>

Answers ( 2 )

  1. No reply hence closing the thread

    0
    2020-07-31T02:20:52+05:30

    I have not seen this before…

    I hope the above logs are taken from
    ConfigMgrSetup.log

    Have you seen this post https://www.anoopcnair.com/configmgr-site-reset-issues-sccm-fix/

    I didn’t see more details about availability groups in this scenario

    I recommend raising a support case with Microsoft css

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .