AlteredAdmin Posted November 16, 2021 Posted November 16, 2021 (edited) Trying to remove smsprovider from an old server to decommission. However when i follow this guide https://www.prajwaldesai.com/uninstall-sms-provider-role/ I get the below error in Configmgrsetup.log. 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 11/16/2021 8:09:50 AM 480 (0x01E0) ERROR: Failed to detect whether always on is enabled or not. Configuration Manager Setup 11/16/2021 8:09:50 AM 480 (0x01E0) ERROR: Could not connect to the SQL Server SCSQL-MEM.DOMAIN.org to determine if the server is always on, or failed to run the query. Configuration Manager Setup 11/16/2021 8:09:50 AM 480 (0x01E0)~ ===================== Failed Configuration Manager Server Setup - Modify Site Settings ===================== Configuration Manager Setup 11/16/2021 8:09:50 AM 480 (0x01E0) Yes, the Site can connect to the database, and it is online. I think its running into a permissions issue. But not sure where to go from here. Thoughts? Edited November 16, 2021 by AlteredAdmin
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now