配置管理器 The Server cannot be deleted.
How to Resolve “The Server Cannot be Deleted” 错误 When Migrating to SQL 2016. When I migrate to SQL 2016, I get this 错误:
The Server cannot be deleted because it contains the following roles
Problem
We’re not able to remove the old remote SQL 服务器. The Server still appears in the Site System Roles and if we try to remove the Site Database server role (remove is not greyed out) we received the 错误: “The server cannot be deleted because it contains the following roles:”
We also tried to change the reg keys under SMS_Site_Componets_Manager\Multisite Componet Server\”Name of remote SQL”\Deinstallation Start Time\ set to 1.
解决方案
Run the following query in SQL 管理工作室 in order to find and replace the orphaned relationships.
Change with the corresponding names in < > and run against the SCCM DB :
use CM_<sitecode>
declare @ServerName varchar(15)
set @ServerName=’<orphanFQDN>‘
delete from statusmessages where machinename=@ServerName
delete from Summarizer_Components where MachineName like ‘%’+@ServerName+’%’
delete from summarizer_sitesystem where sitesystem like ‘%’+@ServerName+’%’
delete from statusmessageinsstrs where insstrvalue like ‘%’+@ServerName+’%’
delete from sysreslist where servername=@ServerName
delete from sc_sysresuse where nalpath like ‘%’+@ServerName+’%’在那之后, reboot the Primary Site. This will remove the server from your Management Console and 配置管理器 数据库.
