Cannot run scom console after move operationdatabase to another server

Question

hi all

pls i move sql database operationmanager(AC,,DW) to new sql server, but if i try run scom console, the console return:

I try run, without effect. Thanx

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'clr enabled', 1;

GO

RECONFIGURE;

GO

error message :

Date: 10.02.2025 8:02:01

Application: Operations Manager

Application Version: 10.25.10132.0

Severity: Error

Message:

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65539. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:

System.IO.FileLoadException: Could not load file or assembly 'microsoft.enterprisemanagement.sql.userdefineddatatype, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A)

System.IO.FileLoadException:

at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)

at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)

at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)

at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.Load(String assemblyString)

thanx

Answer 1

Hi,

If after installing System Center Operations Manager, you move the Operations Manager operational or data warehouse database to a different SQL Server instance, you need to follow the steps below to reconfigure the management group to reference the new TCP/IP Port, instance name, or computer name.

https://learn.microsoft.com/en-us/system-center/scom/manage-move-opsdb?view=sc-om-2025

After try all the steps. If the issue still persists, please check the event log for Operations Manager.

---

If the old SQL server is still available, we can perform a physical-to-virtual (P2V) conversion, allowing us to use the VHD file anywhere.

Disk2vhd is a utility that creates Virtual Hard Disk (VHD) versions of physical disks for use in Microsoft Virtual PC or Hyper-V virtual machines.

You can download Disk2vhd from the Microsoft Sysinternals website