Configuring Endpoint Central MSP to make it use MSSQL Server as the database

How to configure Endpoint Central MSP to make it use MSSQL Server as the database?

Endpoint Central MSP extends support for using MSSQL database for storing the configuration and data. This document will explain the steps,

    1. To configure MS SQL as the back-end database for Endpoint Central MSP server
    2. 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 build #80256 or above. Update your Endpoint Central MSP server here before following any of these steps.

Hardware Requirements for SQL Server

The hardware requirements for SQL server include the following:

No. of Computers/Devices Managed Processor Information RAM Size Hard Disk Space
1 to 5000 Intel Core i7 (6 core/12 thread) 3.2 GHz. 12 MB cache 8 GB 30 GB*
5001 to 10000 Intel Xeon E5 (8 core/16 thread) 2.6 GHz. 20 MB cache 16 GB 40 GB*
10001 to 15000 Intel Xeon E5 (12 core/24 thread) 2.7 GHz. 30 MB cache 32 GB 80 GB*
15001 to 20000 Intel Xeon E5 (14 core/28 thread) 2.7 GHz. 30 MB cache 64 GB 120 GB*

* May increase dynamically according to the frequency of scanning.

Note :

  • Endpoint Central MSP supports MS SQL 2008 or later versions. 

 

Change the Database Server to MS SQL

The following steps will explain you, to backup the data from the old server, change the database server and restore the data in the MS SQL database.

      1. Click here and know the steps to configure SQL server (Proceed with step 2 if the SQL server is already configured).
      2. Migrating the database to SQL server

        From the computer where Endpoint Central MSP server is installed, perform the steps below:

        1. Stop Endpoint Central MSP server
        2. Execute the script changeDBServer.bat available under <Desktop Central MSP Home>/bin directory. This invokes the Database Setup wizard.
        3. Select Database Type as SQL Server
        4. Specify the Host Name where SQL Server is installed
        5. From the list of available SQL server instances, select the instance on which you wish to run the database.
        6. You can choose to authenticate the database connection either using Windows Authentication or SQL Server Authentication. Choose the required authentication and provide the credentials.
        7. Click the checkbox to enable NTLM authentication.
        8. Have the "Migrate Data from Existing Database" check box enabled if you want to migrate your existing database to MSSQL.
          Note: This is applicable only if you wanted to migrate your existing database to MS SQL. If you are trying to create a fresh set up, then you can ignore this step.
        9. Click Save to save and complete the SQL Server Configuration. It may be noted that it will take a few minutes to configure the settings on the SQL Server.

           

          Database Setup Wizard - Windows Authentication

          Fig: Windows Authentication

          Database Setup Wizard - SQL Server Authentication

          Fig: SQL Server Authentication

          Note :

          • One of the best practise recommended is to, Click Test to check whether a connection could be established with the given credential.
          • This might take several minutes, the size of your database determines the time taken.

You can start using Endpoint Central MSP which has been migrated from the previous location.

Remote Desktop & Mobile Device Management Software for MSPs trusted by