SCCM Run Script feature stopped working

Solution/Workaround:

1. Recreate the SMS SSL Certificate:
• The issue might be related to SSL certificate problems. Recreating the SMS SSL certificate can help resolve any issues with secure communication between SCCM and the clients.

Steps to recreate the SMS SSL certificate:

• Go to Configuration Manager Console.
• Navigate to Administration > Security > Certificates.
• Right-click on SMS Server Authentication Certificate, and select Delete.
• After deleting the certificate, select Create Certificate and follow the prompts to create a new SSL certificate for SMS communication.
1. Verify SQL Service Broker:
• The SQL Service Broker might not be enabled, which can interfere with the proper operation of scripts and certain SCCM tasks. To ensure it is enabled:

Steps to verify and enable SQL Service Broker:

• Open SQL Server Management Studio (SSMS).
• Connect to the SCCM database instance.
• Run the following SQL query to check the status of the Service Broker:

SELECT is_broker_enabled

FROM sys.databases

WHERE name = 'CM_' + <Your SCCM Database Name>;

• If the value of is_broker_enabled is 0 (which means it is disabled), you can enable it by running:

ALTER DATABASE <Your SCCM Database Name> SET ENABLE_BROKER;

• Once the SQL Service Broker is enabled, restart the SQL Server service to apply the changes.

These steps address the potential root causes related to SSL certificate issues and SQL Service Broker, which can affect SCCM script execution.