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