After the SQL database has been migrated to a new instance the "server.xml" file will need to be updated with the new database information. The default location of this file on the DCS Server is as follows:
"C:\Program Files (x86)\Symantec\Data Center Security Server\Server\tomcat\conf\server.xml"
***PLEASE MAKE A BACK-UP OF THIS "server.xml" FILE PRIOR TO SAVING CHANGES***
There will be three lines in this file that each begin with a "<Resource auth=" tag.
<Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="25" logAbandoned="true" maxActive="75" maxIdle="50" maxWait="30000" minEvictableIdleTimeMillis="55000" minIdle="25" name="Database-Console" password="1234567890abcdefghijklmnopqrstuvwxyzABCD" removeAbandoned="true" removeAbandonedTimeout="300" testOnBorrow="true" timeBetweenEvictionRunsMillis="34000" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://192.168.1.223/SCSPDB;instance=scsp;integratedSecurity=false" username="scsp_ops" validationInterval="34000" validationQuery="SELECT 1"/> <Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="125" logAbandoned="true" maxActive="425" maxIdle="175" maxWait="30000" minEvictableIdleTimeMillis="55000" minIdle="125" name="Database-Agent" password="1234567890abcdefghijklmnopqrstuvwxyzABCD" removeAbandoned="true" removeAbandonedTimeout="300" testOnBorrow="true" timeBetweenEvictionRunsMillis="34000" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://192.168.1.223/SCSPDB;instance=scsp;integratedSecurity=false" username="scsp_ops" validationInterval="34000" validationQuery="SELECT 1"/> <!-- UMC DB Resource --> <Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="34" logAbandoned="true" maxActive="277" maxIdle="233" maxWait="30000" minEvictableIdleTimeMillis="55000" minIdle="89" name="Database-UMC" password="1234567890abcdefghijklmnopqrstuvwxyzABCD" removeAbandoned="true" removeAbandonedTimeout="300" testOnBorrow="true" timeBetweenEvictionRunsMillis="34000" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://192.168.1.223/dcsc_umc;instance=scsp;integratedSecurity=false" username="umcadmin" validationInterval="34000" validationQuery="SELECT 1"/>
The hostname/IP of the SQL Enterprise Database will need to be updated on the "url=" portion of these three lines as follows:
url="jdbc:jtds:sqlserver://192.168.1.223/SCSPDB;instance=scsp;integratedSecurity=false"
In the above example the "192.168.1.223" entry will need to be updated to the new hostname/IP of the migrated database.
Please note that before modifying the "server.xml" file that the DCS Services should be turned off. (See the image below for reference):
Once the "server.xml" file has been successfully modified, the services can be turned back on and the DCS server's database should be properly migrated.