Your network contains a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) environment. The environment contains a primary site server named Server1 and a server named Server2 that…

When the SQL Server moves to a new machine (Server3), the Service Principal Name must be registered for the new SQL Server service account so the site server can authenticate via Kerberos. After SPN registration, ConfigMgr Setup must be run in site recovery mode, which restores the backed-up database and updates all internal site configuration references to point to Server3 - this is the only supported full recovery path.

Restoring the database through SSMS alone skips SPN registration and bypasses the ConfigMgr Setup recovery process, leaving site configuration broken and Kerberos authentication unresolvable.

While this option also registers the SPN, the second step it prescribes differs from the required ConfigMgr Setup site recovery mode, meaning the site configuration would not be properly updated to reference the new server.

Attaching raw SQL database files via SSMS is not a supported ConfigMgr recovery method and omits both SPN registration and the ConfigMgr Setup recovery workflow needed to restore full site functionality.