Using MSSQL database

Setup & Agent Installation
- Architecture
- Adding Domains / Workgroup
Remote Control
Tools
Auditing & Reports
- Generating and Exporting Reports
- Recording Remote Sessions
- Generating and Exporting Reports
- Recording Remote Sessions
Privacy & Security
General

How to configure Remote Access Plus to make it use MS SQL server as the database?

Remote Access Plus extends support for using MS SQL database for storing the configuration and data. This document will explain the steps to:

Configure MS SQL as the back-end database for Remote Access Plus Server.
Set up a fresh MS SQL database or migrate data from an existing database to a new MS SQL database.

This migration is applicable only for Remote Access Plus build 10.0.457 or above. Update your Remote Access Plus 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 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:

Remote Access Plus supports MS SQL 2005 or later versions.
This document is applicable for migrating Remote Access Plus from PgSQL to MSSQL and one MSSQL server to another.

Change the Database Server to MS SQL

The following steps will explain how to backup the data from the old server, change the database server, 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:
1. Choose Start --> Run and type services.msc.
2. Ensure that the "SQL Browser" service has been started. If not, start the service.
3. Open the SQL Server Configuration Manager from the Start menu.
4. Expand SQL Server Configuration Manager (Local) and navigate to SQL Server Network Configuration.
5. 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.
6. 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 you configure Windows firewall to allow access to SQL server. Refer to this document for more information.
Migrating the database to SQL server
From the computer where Remote Access Plus server is installed, perform the steps below:
1. Stop Remote Access Plus service.
2. Execute the script changeDBServer.bat available under <Remote Access Plus 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" checkbox enabled if you want to migrate your existing database to MSSQL.
  Note: This is applicable only if you want to migrate your existing database to MS SQL. If you are trying to create a fresh setup, then you can ignore this step.
9. Click Save to save and complete the SQL Server Configuration. Note that it may take a few minutes to configure the settings on the SQL Server.
  
  Fig: Windows Authentication
  
  Fig: SQL Server Authentication
  Note :
  - One of the best practices recommended is to click Test to check whether a connection could be established with the given credentials.
  - This might take several minutes; the size of your database determines the time taken.

You can start using Remote Access Plus which has been migrated from the previous location.

Identity and access management

Unified service management

Unified endpoint management and security

IT operations management and observability

Security information and event management

Advanced IT analytics

Low-code app development

Cloud solutions for enterprise IT

IT management for MSPs

Active Directory management Manage, track, and secure Active Directory

Identity governance and administrationOrchestrate user identity management and access controls for Zero Trust

Privileged access managementControl and secure privileged access to critical enterprise systems

Enterprise and IT service managementDeliver a consistent employee experience across business functions

Customer service managementBuild a one-stop portal for customers with efficient account management

IT asset managementCentralize and automate the complete IT asset life cycle

SIEM Spot, investigate, and neutralize security threats

Log and compliance managementGain deeper visibility into security events and ensure compliance

Security auditingAudit Active Directory, cloud platforms and files to enhance your security posture

Endpoint management and protection platform (UEM and EPP)Secure and manage endpoints to protect your IT assets effectively

Endpoint managementAchieve intelligent IT device management with zero user intervention

Endpoint securityDefend against threat actors with proactive and reactive measures

Full-stack observability and digital experience monitoringAchieve end-to-end visibility, proactive issue resolution, and enhanced security

Network and server performance monitoringEnsure network, server, and storage reliability with AI-powered insights

IT incident managementEfficiently manage and resolve IT incidents while ensuring transparency

DNS and DHCP managementOptimize IP address and domain management

Cloud cost managementRight-size and take control of your cloud costs

IT analyticsConnect to your IT applications and visualize all facets of your IT

Cloud-native solutions for IT managementMonitor, manage, audit, and secure your multi-cloudand hybrid infrastructure

Business applications for ITBoost productivity and improve team collaboration

Custom solution builderBuild tailor-made apps to automate operations at your organization

Solutions for MSPsGrow your MSP business with scalable and secure IT management solutions

How to configure Remote Access Plus to make it use MS SQL server as the database?

Hardware Requirements for SQL Server

Change the Database Server to MS SQL

Active Directory
management Manage, track, and secure Active Directory

Identity governance
and administrationOrchestrate user identity management and access controls for Zero Trust

Privileged access
managementControl and secure privileged access to critical enterprise systems

Enterprise and IT service
managementDeliver a consistent employee experience across business functions

Customer service
managementBuild a one-stop portal for customers with efficient account management

IT asset
managementCentralize and automate the complete IT asset life cycle

Network and server
performance monitoringEnsure network, server, and storage reliability with AI-powered insights

IT incident
managementEfficiently manage and resolve IT incidents while ensuring transparency

Cloud-native solutions for IT managementMonitor, manage, audit, and secure your multi-cloud
and hybrid infrastructure