Microsoft SQL Server - Devolutions Documentation

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 the offline mode for when the server or network is unavailable.
Supports full entry logs and attachments.
Supports vault s to organize thousands of entries.

Key points to consider:

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.
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 groups.

Configuration

Consult Configure SQL Server for more information on the configuration.

Settings

### General{#general-windows}

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

OPTION	DESCRIPTION
Root filter	Enter a root level folder's name to display only its content. Multiple folder names can be added so long as they are separated by a semi-colon (no spaces). Putting a semi-colon at the end of the list also shows all root entries not contained in any folders. The field is case sensitive.
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

| 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.

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

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.

Advanced

OPTION	DESCRIPTION
Caching mode	Determines how the entries will be reloaded in the data source. For more information, please consult Caching.
Sync all vaults (background)	Synchronization ensures that any changes made to a vault,such as updating passwords or adding new sessions, are propagated across all connected devices and users in real-time.
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.

Connection

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

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

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 see Manage cache.
Advanced Settings	Edit the connection string values directly.

Upgrade

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

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.