Microsoft SQL Server

Remote Desktop Manager macOS uses the power of Microsoft SQL Server to save and manage all sessions.

Supported Microsoft SQL Server:

  • 2019 on Windows and Linux (all editions)
  • 2017 on Windows and Linux (all editions)
  • 2016 Service Pack 2
  • 2014 Service Pack 3
  • 2012 Service Pack 4

We also support the following features:

  • Always on availability group
  • Clustering
  • Log Shipping
  • Database mirroring

Highlights

  • Supports user management with a superior security model.
  • Supports Offline mode for when the server or network is unavailable.
  • Supports full entry logs and attachments.

A proper database backup strategy should be implemented to minimize possible data loss.

Active directory in a SQL Server data source is no longer supported in Remote Desktop Manager macOSOS.

Depending on the Recovery Model of the underlying database, some maintenance operations may have to be scheduled to run regularly to maintain the health of the database. Please consult Recovery Model.

Using Database Login is inherently less secure because it means that the end user can connect directly to the database using any tool available. We do have table and column level security, but security conscious organizations would consider this unacceptable. It is recommended to use our Custom login model.

Creating Contained Database Users as mentioned in this article is the supported method with SQL Always On availability group.

Configuration

Consult Configure SQL Server for more information on the configuration.

Settings

Connection

SQL Server - Connection tab
SQL Server - Connection tab

OPTION DESCRIPTION
Name Name of the data source.
Server Name of the server where the data source will be stored.
SQL Server Select your data source between the SQL Server or Azure SQL.
Login Mode Specify the authentication mode to use. Select between:
  • Database login
  • Custom login
User Username to access the SQL server.
Domain Domain to access the SQL server.
Save password By saving the password for your data source you will connect automatically to your SQL Server without having to enter your password every time.
Password Password used to access the SQL server.
Database Name of the database on the SQL server for the utilization of Remote Desktop Manager macOS.
Two factor Enable the 2-Factor Authentication to access your data source.
Test Server Test the connection with the server to validate if the proper information has been provided.
Test Database Test the connection with the database to validate if the proper information has been provided.

Settings

SQL Server - Settings tab
SQL Server - Settings tab

OPTION DESCRIPTION
Repository If using Repositories click on the ellipsis to select the proper Repository.
Auto refresh Set the interval for the automatic refresh.
Ping online method Indicate the preferred ping online method. Select between:
  • None
  • Ping
  • Port scan
Auto go offline Use the data source in offline mode when the ping method does not respond.
Disable lock Disable the option to lock the data source directly. You can still lock the application but you will not be prompted for the database password if this option is disabled.

Advanced

SQL Server - Advanced tab
SQL Server - Advanced tab

OPTION DESCRIPTION
Offline mode Determine the Offline mode availability. Select between:
  • Disabled
  • Read-only
  • Read/write
Prompt for offline mode on startup Ask to use the data source in offline mode when the user connects to the data source.
Caching mode Determine how the entries will be reloaded in the data source. For more information, please consult Caching Mode.
Auto refresh Set the interval for the automatic refresh.
Connection timeout Waiting time before a connection timeout.
Command timeout Waiting time before a command timeout.
Allow beta database upgrade Allow beta upgrade of the database (when using a beta version of Remote Desktop Manager).
Manage Cache Manage your cache on your computer to analyse, vacuum, repair or delete it. This can be very helpful if you have offline issues. For more information please follow this link.
Advanced Settings Edit the connection string values directly.

Upgrade

SQL Server - Upgrade tab
SQL Server - Upgrade tab

OPTION DESCRIPTION
Test Server Test the connection with the server to validate if the proper information has been provided.
Create Database Create the database on the SQL server to use Remote Desktop Manager.
Update Database Update the database on the SQL server, if required to use Remote Desktop Manager.
Test Database Test the connection with the database to validate if the proper information has been provided.
View upgrade script... If you wish to process Database upgrade by hand instead of automatically you may use the upgrade script to do so.

User vault

SQL Server - User vault
SQL Server - User vault

OPTION DESCRIPTION
Type Select the type of user vault to use. Select between:
  • Default: use the default user vault, which is stored in the database.
  • None: disable the user vault for all users.
  • Devolutions Online Drive: use a Devolutions Online Drive file (*.dod) as a user vault.