Migrate Opmanager database from default to names instance

Migrate Opmanager database from default to names instance

Hi,

We have our Opmanager DB on a single MSSQL server on the default instance. To improve the uptime of the DB, we want to move the database to a named instance on our SQL cluster.

I have backed up the database and restored onto the cluster and configured the database to use the same username/password as before.

In the  database_params.conf, I tried to edit the conf file adding both the server name and instance port 
(e.g. sqlserver://servername: 52561/OpManagerDB)

and the servername, instance and port 
(e.g. sqlserver://servername/instancename: 52561/OpManagerDB)

but both times, the opmanager service will start and then stop.

I know there is the DB configuration tool but as I understand it, that will create a new DB and not assist in a migration from MSSQL to MSSQL.

Please assist.
Trevor

                  New to ADSelfService Plus?