SQL Server Always On

SQL Server Always On is a high-availability solution introduced by Microsoft to ensure the continuous availability of databases. In Always On mode, two instances can point to the same database. If one instance goes down, the other takes over automatically. Endpoint Central Server supports SQL Always On and it can be configured by following the instructions below:

For New SQL Server Configuration

• If the SQL server is yet to be configured, enter the Virtual IP in the 'Host Name' field while migrating the database to the SQL server.

For Existing SQL Server Configuration

If the SQL server has already been configured, update its settings to use the new Virtual IP address:

• 1. Stop the Endpoint Central Server.
• 2. Open the database_params.conf file located at <Endpointcentral_Server_Installation_Dir>\conf.
• 3. Replace the existing SQL machine IP with the Virtual IP details as shown below:
  • url=jdbc:jtds:sqlserver://Old_Server_name:SQLPort;DatabaseName=desktopcentral
  • url=jdbc:jtds:sqlserver://VirtualIP:SQLPort;DatabaseName=desktopcentral
• 4. Start the Endpoint Central Server.

Acquiring the Master key

When moving the desktopcentral database in MSSQL to an Always-On availability group, you will need a master key to configure Always-On. Follow these steps:

• Stop the Endpoint Central Server service.
• Open a command prompt in administrator mode and navigate to the directory: <Endpointcentral_Server_installation_Dir>\bin
• Execute the batch file: getMasterKey.bat.
• When prompted, enter the Endpoint Central console login credentials.
• You will receive the master key details (as shown in the screenshot below).