Microsoft SQL Server

With the Microsoft SQL Server data source, Remote Desktop Manager uses the power of Microsoft SQL Server to save and manage entries.

Supported Microsoft SQL Server:

  • Microsoft SQL Server 2016/2017/2019/2022 (including Express editions)

The following features are also supported:

  • 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.
  • Supports vault s to organize thousands of entries.

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

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 either Database Login or Integrated Security 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 will consider this unacceptable. It is recommended to use our Custom login model.

Creating Contained Database Users as mentioned in Microsoft's Contained Databases is the supported method with SQL Always On availability group.

Configuration

Consult Configure SQL Server for more information on the configuration.

Settings

General

Microsoft SQL Server – General tab
Microsoft SQL Server – General tab

OPTION DESCRIPTION
Name Enter a name for the data source.
Host Enter the server hostname or IP address.
Login mode Specify the authentication mode to use. Select between:
  • Database login
  • Integrated Security (Active directory)
  • Custom Login
Username Enter the username to access the Azure SQL database.
Password Enter the password to access the Azure SQL database.
Always ask password Prompt for the password when a user connects to the data source.
Allow change username Allow the username to be edited when connecting to the data source.
(Only with Always ask password enabled)
Database Enter the name of the Azure SQL database.
Two factor Enable the Multi-Factor Authentication.
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

Microsoft SQL Server – Settings tab
Microsoft SQL Server – Settings tab

OPTION DESCRIPTION
Root filter Enter the name of a root level folder to display only the entries contained in that folder.
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 data source password if this option is disabled.

User vault

Microsoft SQL Server – User vault tab
Microsoft SQL Server – User vault tab

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.

Upgrade

Microsoft SQL Server – Upgrade tab
Microsoft 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.
Update Database Update the database on the SQL server.
Test Database Test the connection with the database to validate if the proper information has been provided.
Email Schema to Support Send your schema to our support team.

VPN

Open a VPN to access your data prior to connecting to your Microsoft SQL Server.

Microsoft SQL Server – VPN tab
Microsoft SQL Server – VPN tab

Advanced

Microsoft SQL Server – Advanced tab
Microsoft SQL Server – Advanced tab

OPTION DESCRIPTION
Caching mode Determines how the entries will be reloaded in the data source. For more information, please consult Caching.
Connection timeout Set the delay of the connection timeout.
Command timeout Set the delay of the command timeout.
Auto refresh Set the interval for the automatic refresh.
Prompt for offline mode on startup Ask to use the data source in offline mode when the user connects to the data source.
Allow beta database upgrade Allow beta upgrade of the database (when using a beta version of Remote Desktop Manager).
Manage Cache Manage the data source cache. On large data sources caching is a must and will increase performance significantly. For more information, please consult Manage Cache.
More Settings Edit the connection string values directly.