CommitCRM – Business Automation for Successful ITsTrusted Since 2004

SQL Database for RangerMSP

The RangerMSP system provides a reliable, advanced and network-ready shared file-based database.

The SQL Database for RangerMSP is an optional product for the RangerMSP product. SQL Database for RangerMSP includes a SQL-based client/server database server that provides a robust solution for larger networks with many concurrent users and a high-database transaction volume. It provides bulletproof data integrity on networks and increased speed.

SQL also grants you the license to use RangerMSP remotely when using technologies such as Terminal Services or Citrix. This allows remote users to run RangerMSP through a remote session on the server. We also recommend our RangerMSP Web Interface module for remote users.

Live Backup – SQL allows you to backup your data while the system is in use without stopping users and services from working. Everyone can continue working as usual while the backup is performed in the background. Live Backups can also be scheduled and run automatically at defined intervals.

SQL withstands power blackouts, workstation lockups and system crashes without any data loss or corruption. All data access is handled and double-checked on the server, not by each workstation, providing maximum protection. Only the data needed is transmitted across the network wire, a particularly valuable feature for larger databases and a high volume of users on the network. SQL installs in minutes and works effortlessly behind the scenes to protect your data and increase RangerMSP’s speed.

There are no ongoing administrative costs. SQL Database for RangerMSP runs on your server and almost never require any user intervention, settings, periodic maintenance, etc.

VPN – SQL increases performance when using the RangerMSP client over a VPN connection. Data is compressed and only the required data has to travel to/from the server. It also works faster via VPN because RangerMSP executable files can reside on the remote PC. Use RangerMSP over VPN when the the faster option of using it over remote sessions such as RDP is not available.

SQL Database for RangerMSP is an optional add-on product that is licensed and priced according to the number of concurrent open connections to the database, meaning the number of PCs, servers or terminal services sessions who access the SQL database server at the same time.

Frequently Asked Questions

I have already entered data into RangerMSP; will my data be secure after installing SQL?
Yes. All your data and settings will be retained and available following installation of SQL.

How can I determine whether if I need SQL?
SQL is only required when:
1. Your LAN is growing, with an increasing number of concurrent users and a higher database-transaction volume.
2. You want to use remote technologies such as Terminal Services to open a session on your server for remote users.

Does SQL provide additional features to users?
No. SQL is a technology-oriented product. Although SQL enhances RangerMSP’s functionality for larger networks with many concurrent users and a high database-transaction volume and grants the license to use RangerMSP remotely, the feature set of the RangerMSP system remains the same.

Does SQL Database for RangerMSP use Microsoft SQL Server?
No. SQL Database for RangerMSP uses one of Sybase’s database server products, Advantage, as the backend. This helps us achieve high performance, a bulletproof database and a high level of data integrity. It is also easy to install and requires a minimum of ongoing administration.

What operating systems are supported?
You need a server running Windows 2003/2008/2012/2016 Server, Windows 7, Windows 8 or Windows 10. The SQL Database server runs as a Windows service.

What is the difference between RangerMSP licensing and SQL licensing?
The RangerMSP system is licensed and priced according to the number of Active Employees managed in the system, regardless of the number of network PCs on which the RangerMSP Client is installed. The price only increases when it is necessary to purchase additional Active Employee licenses (i.e. manage additional employees in your RangerMSP system). This licensing scheme does not change when using SQL and SQL licenses do not replace the need for Active Employee licenses for RangerMSP.

SQL is an optional add-on product that is licensed and priced according to the number of concurrent open connections to the database, meaning the number of PCs, servers or terminal services sessions who access the RangerMSP database server at the same time.

When using SQL you can still install RangerMSP Client on as many PCs on your network as needed, but the number of PCs, Servers or Terminal Services sessions who can use RangerMSP simultaneously is limited to the number of SQL concurrent-connection licenses you’ve purchased.
SQL server can be purchased initially with licenses for 5, 10, or 15 concurrent connections. To customize you system for a larger number of connections (up to 250), you can purchase additional 5-SQL-connection packages.

For example, if you manage 15 employees in RangerMSP, you need 15 Active Employee licenses. When you decide to use SQL you may find that you only need to purchase a 5 concurrent connections license if no more than 5 users are running RangerMSP on your local network at the same time.

Do RangerMSP Web Interface, RangerMSP Alerts Server, RangerMSP Email Connector or RangerMSP RMM Server also use SQL?
Yes. RangerMSP Web Interface (for customers and/or employees), RangerMSP Alerts Server, RangerMSP Email Connector and RangerMSP RMM Server take full advantage of SQL. You should keep in mind that they utilize a total of one additional concurrent SQL connection license. Just one SQL database connection license is needed for all of these modules, no matter how many modules are in use or how many employees or clients connect via the RangerMSP Web Interface.

Will I ever need to upgrade SQL Database for RangerMSP?
Like many other commercial products, you may be required to upgrade when a new major version is released. This will most likely be when the backend database server we use, Sybase’s Advantage, releases a new major version, which usually occurs every couple of years.

Does RangerMSP Upgrade Plan include free SQL updates?
The SQL Database for RangerMSP is an additional product that includes third-party licenses and therefore only minor SQL updates are included, while major version upgrades are not. SQL major version upgrades are usually released once every two years and are offered for an attractive price that is considerably lower than a new SQL license.