Trying to remove smsprovider from an old server to decommission.
Question
This is kind of a long one, it’s a tale of two servers.
SCCM-PS(Server 2012) – This server used to be the primary site server however it was replaced with CM-PS. SCCM-PS still was listed as an SMS provider role.
CM-PS (Server 2016) – This server is the new primary site server, and has been in production for a while, from about 2016.
I have noticed that when SCCM-PS is powered down the console does not connect, it just sits flashing at connecting to site database. Even though the console is pointed to CM-PS. What is causing this? This is something that was happening even before what i did below. Unless its randomly selecting a SMS provider and I’m getting lucky hitting the offline one each time? but the SMS provider for SCCM-PS has been removed, as of this morning. Again this was happening before the below and still is.
I need to Decommission SCCM-PS the only two roles that are left are Component server & Site System.
This morning I removed the SCCM-PS SMS provider following this guides . I could not use my account to do it cause it was hanging on the below.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I was able to get past this by running the setup.exe as the database ad account. IT did remove the SMS provider. But did give some errors, However SCCM does appears to be working fine, and the SMS provider is no longer listed in SMS provider location on site properties. but the console still will not connect when i shut down SCCM-PS
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*** [42000][15151][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter the role ‘smsdbrole_siteprovider’, because it does not exist or you do not have permission. Configuration Manager Setup 11/16/2021 10:45:17 AM 8636 (0x21BC)
ERROR: SQL Server error: [42000][15151][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter the role ‘smsdbrole_siteprovider’, because it does not exist or you do not have permission. Configuration Manager Setup 11/16/2021 10:45:17 AM 8636 (0x21BC)
INFO: Executing SQL Server command: <EXEC sp_droprolemember N’smsdbrole_siteprovider’, N’DOMAINSCCM-PS$’> Configuration Manager Setup 11/16/2021 10:45:17 AM 8636 (0x21BC)
WARNING: Failed to remove account, SQL Server error: <> Configuration Manager Setup 11/16/2021 10:45:17 AM 8636 (0x21BC)
INFO: Create notification file (11_SCCM-PS.DOMAIN.org.CMD) for SMS_CERTIFICATE_MANAGER Configuration Manager Setup 11/16/2021 10:45:17 AM 8636 (0x21BC)
INFO: DeinstallSDK, regsrc.Remove(&provCfg) return 0. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: regSDKParent.DeleteKey return 0. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: Delete Providers root Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: CNtNet::Remove SDK Machine from Local group, return:b11b8eb8. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: Updating SMSData Table Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: SQL Connection succeeded. Connection: SCSQL-MEM.DOMAIN.ORG CM_FSC, Type: Secure Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: Sid for this site server is S-1-5-21-636618257-2613738635-33974680-1358414. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: pModifyInfo->bNoChange: 0, g_SetupCmdLine.bResetSite:0. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: Initializing the site control file… Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
CSiteControlSetup::Create_BackupSQLCert : Failed to get sms database file path. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
CSiteControlSetup::SetupCertificateForSSB : Failed to create/backup SQL SSB certificate. Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
ERROR: Failed to set up SQL Server certificate for service broker on “SCSQL-MEM.DOMAIN.org” . Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
~===================== Failed Configuration Manager Server Setup – Modify Site Settings ===================== Configuration Manager Setup 11/16/2021 10:45:18 AM 8636 (0x21BC)
<11-16-2021 10:46:17> ***************************************************** 1/1/1601 12:00:00 AM 2022964656 (0x7893FDB0)
<11-16-2021 10:46:17> ***** Exiting ConfigMgr Setup Bootstrapper ***** 1/1/1601 12:00:00 AM 2022964656 (0x7893FDB0)
<11-16-2021 10:46:17> ***************************************************** 1/1/1601 12:00:00 AM 2022964656 (0x7893FDB0)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Thoughts?
Answers ( 5 )
I don’t understand the scenario here … Do you just have a cosmetic issue here? It shows only in the console and you want to remove it?
No its not cosmetic. I also made a post regarding the same thing over on reddit.
reddit.com/r/SCCM/comments/qv8u9r/trying_to_remove_smsprovider_from_an_old_server
If you don’t mind take a look over that post and let me know what you think.
I was able to get the SMS provider removed by running the setup.exe as the account that has access to the database. After that the SMS provider was removed from SCCM-PS.
My main question is why the old site server SCCM-PS when shutdown the console would not connect to CM-PS (the new site server that has been in production since 2016)
But now that i have waited and Component Server was removed from SCCM-PS i can now shutdown SCCM-PS and the console connects to CM-PS.
Thoughts on why that was happening?
I did read that thread before 🙂
I don’t have any idea on this …you might need to check the logs and understand what could be the issue.
And probably reproduce the issue in staging environment etc
Closing this ticket because of no response