Issue removing old SQL Server from ConfigMgr

Situation before migration:

1x Primary Site ConfigMgr 2012 R2 no CU (OS Win 2008 R2) – no OS upgrade Support (*)
2x Secondary Sites 2012 R2 no CU
1x SQL Server 2008 R2 SP2 no CU
2’500 Clients worldwide

Goal:

1 Primary Site Current Branch 1511
New OS Windows Server 2012 R2
1 local installed SQL Server
no more Secondary Sites
several DP’s around the world

Most of the things went smoothly but at one point for now we stuck. We’re not able to remove the old remote SQL Server. 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 recieve the error: “The Server cannot be deleted because it contains the following roles:”

811577

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.

811594

 

Solution

Run the following Query in SQL Management Studio 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+’%’

 *************************************************************

After that, reboot the Primary Site. This will remove the server from your Management Console and ConfigMgr Database.

(*)
ConfigMgr CB 1602 no supports OS Upgrade from 2008 R2 to 2012 R2. Make sure you uninstall WSUS first.

https://technet.microsoft.com/en-us/library/mt622084.aspx?f=255&MSPPError=-2147217396

Cheers, Al

 

 

 

 

 

Merger of itnetx gmbh and Syliance IT Services GmbH

logo-original

BERN/ZÜRICH. Two of the most important companies in the field of Microsoft Workplace, Cloud and Management Solutions, Syliance IT Services GmbH and itnetx gmbh, will merge as of 1st July 2015 to form the new company, itnetX AG.

A situation of market collaboration will prove to be fruitful: „This fusion makes sense and is important”, says Markus Erlacher, CEO of itnetx gmbh, „we will combine our energies, create synergy and send a clear signal of intent that we are committed to growth and business expansion”. The merger of the two companies will strengthen the market leadership and enable more customers more intensive treatment from the company offices in Bern and Glattbrugg, Zürich.

„The ability to offer integrated solutions and services in the rapidly-evolving IT markets is essential for our success”, says Dieter Gasser, CEO of Syliance IT Services GmbH. „With this merger we are consolidating and expanding our range of services; we can offer our customers proprietary software solutions and architecture and process consulting, in addition to systems integration and managed services”.

The newly-formed itnetX AG is aiming at changes in the IT market and the Microsoft Cloud First, Mobile First strategy lies at the heart of the business model. The new organization comprises 5 strategic business units: Modern Workplace Solutions, Management Solutions, Cloud and Datacenter Solutions, and Software Solutions, all of which are complemented by Managed Services.

With focus on Microsoft-based solutions, the future portfolio will include SaaS offerings and services such as Office 365, Microsoft Azure, Microsoft Intune and System Center, Windows Client and Windows Server. The whole package is rounded off with a range of software products targeted at Private and Public Cloud environments. This allows itnetX AG to advise customers much more comprehensively and bring added value to their business.

The work of itnetX AG also includes a continued active participation in the community with various blogs, book publications, 5 highly qualified MVPs (Most Valuable Professional) and private events such as the annual System Center Universe Europe (www.systemcenteruniverse.eu).

More information available upon request via Email: info@itnetx.ch or visit www.itnetx.ch.

Markus Erlacher Dieter Gasser

CEO itnetx gmbh CEO Syliance IT Services GmbH