In the past we installed the Enterprise Manager server as a workgroup server with a local SQL database in SQL Express. All other Veeam related servers are in a backup domain. The EM and B&R server are running version 9.5 update 3.
Lately I noticed that the database size has reached 10 GB and it is getting very slow. I have tried to move the database to the SQL server where also the Veeam B&R database resides. All other Veeam related servers are in a backup domain.
But I am running into some problems here.
I have SQL Management Studio on the EM server and I am able to connect to the SQL server where I want to place the EM database.
On the EM server is stopped all VEEAM services, i stopped (and disabled) all SQL (express) services.
I then copied the VeeamBackupReporting.mdf and VeeamBackupReporting_log.ldf to the other SQL server. I attached the database without any errors.
I changed the following registry entries om the EM server (the database name did not change);
[HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup Catalog]
[HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup Reporting]
After this I tried to start the Veeam services but they failed, mostly with the error " SQL server is not available Error: SQL server is not available".
Most knowledgebase articles point to these registry entries, also Veeam.Backup.DBConfig.exe can be used (but this file is only available on the B&R server itself.
The only thing I can imagine is this occurs because the SQL versions are different. The SQL Express version on the EM server is SQL 2012 (11.0.3000.0) and the SQL Standard I want to use is SQL 2016 (13.0.4466.4).
Although attaching the database on the new SQL server is no problem and I can open the underlying folders.
For now I have restored the old situation and it works again but I still want to change the configuration.
Does anyone have an idea why this is failing and how to overcome this?