Dedicated SQL Server instance prerequisite check failed

ISSUE

Configuration Manager prerequisite refuses to pass due to Dedicated SQL Server instance prerequisite check failure.

Configuration Manager Prereq    4332 (0x10ec)    INFO: Checking for to see if SQL instance SITEDB.LAB.LOCAL\ is used by another SCCM installation.
Configuration Manager Prereq    4332 (0x10ec)    ERROR: SQL instance SITEDB.LAB.LOCAL\ is used by another SCCM installation.
Configuration Manager Prereq    4332 (0x10ec)    PSSITE.LAB.LOCAL;    Dedicated SQL Server instance;    Error;    Configuration Manager requires a dedicated SQL Server instance to host its site database.

Configuration Manager requires a dedicated SQL Server instance to host its site database. You selected a SQL Server instance that hosts the site database for another Configuration Manager site. Select a different SQL Server instance for this new site to use, or resolve the conflict by uninstalling the other site or moving its database to a different SQL Server instance.

REASON

You can come across this issue if you are using a server for sql server which had once been used for Configuration Manager.

This is usually caused by two reasons:

• Remnants in registry: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS]
• Stale Configuration Manager entries in the master.sys.service_broker_endpoints table

Solution

• Delete [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS]
• Remove the stale entries in master.sys.service_broker_endpoints: DROP ENDPOINT [Endpoint-Name-Like-ConfigMgrEndpoint];

References

• https://docs.microsoft.com/en-us/mem/configmgr/core/servers/deploy/install/list-of-prerequisite-checks#dedicated-sql-server-instance