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 )
No reply hence closing the thread
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