I need to know how to configure SQL server information on ZCM configuration file? I understand that ZCM requires the Database server name and Database information while installing ZCM, but I think there should be a way where you can give (assign) other SQL server Database name, login password.

My Question is once you install ZCM with given server (SQL Server) name; can we change the server/instance/Database/port/login/password/timeout information?

Can we chose if/else or 'OR' statement to connect the Database server in the file "at the time of Database Failure" either replaced server or Mirror server or Snapshot server information?

Appreciate any recommendations or suggestion