Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Patch Manager > Need to place a load balancer between the PAS and the Database server

Need to place a load balancer between the PAS and the Database server

Table of contents
Created by Christine Magbuo, last modified by Rodim Suarez on Jun 29, 2016

Views: 11 Votes: 0 Revisions: 3



This article describes the steps on how to place a load balancer between the PAS (Primary Application Server) and the database server.


All Patch Manager versions


Adding db-balancer shall be fine. The Migrate a local or remote Patch Manager database to a Remote SQL Server article has information on how to point to a different DB. If the DB and IP are the same, Patch Manager will work without changes. 


The best option is to put db-balancer on the same address that was before the DB. In this case, for any program all connection strings shall stay the same and this will minimize changes. If the connection string from Patch Manager to its DB is going to change, the steps for moving DB shall help.


You may use DBhelper to change the connection string, and/or you may change hosts file.

Note: You may change the hostname in the etc/hosts file of the the PAS to point to the new load balancer VIP Address. It will make the change much easier, and follows the same logic as migrating the IP address of the DB into the Loadbalancer.


Last modified
18:26, 28 Jun 2016