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)>

in progress 0
Sameer Pradhan 4 days 1 Answer 33 views Beginner 0

Answer ( 1 )

  1. 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

Leave an answer

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