If the host names or IP addresses of ALM server and database server are changed.

Recently our ALM POC server DB got changed from one server to other server. Inorder to point to new server we followed below steps to point to the new server.

Solution :

Step 1: Change siteadmin.xml
            
           Login to the ALM server where ALM is installed and navigate to the below path 
           
           "C:\ProgramData\HP\ALM\jboss\server\default\deploy\20qcbin.war\WEB-INF\siteadmin.xml".

           We need to change the content inside the tag "<DbUrl>DbUrl>", which will change the IP address of the DB server that contains siteadmin DB.

Step 2: Change DBSERVERS table

           Access to DB server. Open siteadmin DB, then modify the IP address or hostname of DB server under the table "DBSERVERS"

Step 3: Change PROJECTS table

           Access to DB server. Open siteadmin DB, then modify the IP address and hostname of DB server under the table "PROJECTS"

Step 4: Restart ALM service.

Now the ALM will points to New DB Server