How to configure MS SQL Server database for Endpoint Central?
Note :
- Endpoint Central Supports MS SQL 2008 or later versions.
- If you are using "Failover Server" contact our support team for migration assistance.
- This document is applicable for migrating Endpoint Central from PGSQL to MSSQL and one MSSQL server to another MSSQL server.
- It is recommended to use Endpoint Central's backup method for uninterrupted workflow.
- Endpoint Central does not support MSSQL to PGSQL migration, instead perform Backup and restore for MSSQL to PGSQL setup.
This document covers the following:
- To configure MS SQL as the back-end database for EndpointCentral Server.
- To set up a fresh MS SQL database or migrate data from an existing database to new MS SQL database.
This migration is applicable only for Endpoint Central build 10 or above. Upgrade your server here before following any of these steps.
Hardware Requirements for SQL server
The hardware requirements for SQL server include the following:
| No. of endpoints to be Managed |
Processor Details |
RAM Size |
Hard Disk Space |
| 1 to 250 |
Intel Core i3 (2 core/4 thread) 2.0 Ghz 3 MB cache |
4 GB |
5 GB* |
| 251 to 500 |
Intel Core i3 (2 core/4 thread) 2.4 Ghz 3 MB cache |
4 GB |
10 GB* |
| 501 to 1000 |
Intel Core i3 (2 core/4 thread) 2.9 Ghz 3 MB cache |
4 GB |
20 GB* |
| 1001 to 3000 |
Intel Core i5 (4 core/8 thread) 2.3 GHz |
8 GB |
30 GB* |
| 3001 to 5000 |
Intel Core i7 (6 core/12 thread) 3.2 GHz. 12 MB cache |
8 GB |
200 GB* |
| 5001 to 10000 |
Intel Xeon E5 (8 core/16 thread) 2.6 GHz. 20 MB cache |
16 GB |
250 GB* |
| 10001 to 15000 |
Intel Xeon E5 (12 core/24 thread) 2.7 GHz. 30 MB cache |
32 GB |
500 GB* |
| 15001 to 20000 |
Intel Xeon E5 (14 core/28 thread) 2.7 GHz. 30 MB cache |
64 GB |
500 GB* |
| 20001 to 25000 |
Intel Xeon (14 core/28 thread) 2.7 GHz. 30 MB cache |
64 GB |
1 TB* |
| 25001 to 30000 |
Intel Xeon (20 core/40 thread) 3.6 GHz. 50 MB cache |
128 GB |
1 TB* |
* May increase dynamically according to the frequency of scanning.
Changing SQL server machine name\IP in the Endpoint Central server
To just update the name/IP details in the central server without any migration, follow the steps below.
- Stop the Endpoint Central server.
- Open database_params.conf in the location\conf
- Update the old SQL server IP/hostname with the new server details as shown:
- url=jdbc:jtds:sqlserver://Old_Server_name:SQLPort;DatabaseName=desktopcentral
- url=jdbc:jtds:sqlserver://New_server_name:SQLPort;DatabaseName=desktopcentral
- Save the file and then start the Endpoint Central server.
Migrate the Endpoint Central Server Database to MSSQL
The following steps will explain you,
1. To backup the data from the old server
2. Migrate the Endpoint Central server database and restore the data in the MSSQL database.
- Click here and know the steps to configure SQL server (Proceed with step 2 if the SQL server is already configured).
Perform the steps below from the computer where MS SQL Server is installed,
- Choose Start --> Run and type services.msc.
- Ensure that "SQL Browser" service has been started. If not, start the service.
- Open the SQL Server Configuration Manager from the Start menu
- Expand SQL Server Configuration Manager (Local) and navigate to SQL Server Network Configuration.
- Choose the Instance on which you wish to run the database and check if TCP/IP ports are enabled. If not, right-click on TCP/IP and enable it.
- You should restart the SQL Service after you enable TCP/IP. Select SQL Server Services from the left pane, right-click the instance and choose Restart.
Note: Ensure that the you configure Windows firewall to allow access to SQL server. Refer this document for more information.
- Migrating the database to SQL server
From the computer where Endpoint Central Server is installed, perform the steps below:
Note: While migrating the database, the user needs to have the dbowner privilege for the master database. Once the DB migration is done, the user needs to have dbowner privilege for desktopcentral and master database to ensure smooth operation.
- Stop Endpoint Central Server
- Execute the script changeDBServer.bat available under <Server_Ins_Dir>/UEMS_CentralServer/bin directory. This invokes the Database Setup wizard.
- Select Database Type as SQL Server
- Specify the Host Name where SQL Server is installed
- From the list of available SQL server instances, select the instance on which you wish to run the database.
- You can choose to authenticate the database connection either using Windows Authentication or SQL Server Authentication. Choose the required authentication and provide the credentials.
- Click the checkbox to enable NTLM authentication.
- Have the "Migrate Data from Existing Database" check box enabled if you want to migrate your existing database to MSSQL.
- Click Save to save and complete the SQL Server Configuration. It will take a few minutes to configure the settings on the SQL Server.
Fig: Windows Authentication
Fig: SQL Server Authentication
Note :
It is recommended to validate once if the connection could be established with the given credentials.
You can start using Endpoint Central which has been migrated from the previous location.
To configure the Always-on functionality of the SQL server, refer here - SQL Server Always On
Free Edition