Microsoft Azure SQL

With a Microsoft Azure SQL workspace, Remote Desktop Manager uses the Microsoft cloud platform to save and manage entries.

The following features are also supported:

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

Minimum requirement for an Azure SQL database for Remote Desktop Manager

Microsoft Azure SQL offers different service tier in its purchase model for DTUS. We recommend at minimum a Standard tier package S0 for 5 users and more. Visit their website for more information.

Highlights

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

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

Configuration

Consult Configure Azure SQL for more information on the configuration.

Settings

Windows

General

OPTION	DESCRIPTION
Name	Enter a name for the workspace.
Host	Enter the server hostname or IP address.
Login mode	Specify the authentication mode to use. Select between: Database login Custom login Active Directory Password Active Directory Integrated Active Directory Interactive (with MFA support)
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 workspace.
Allow change username	Allow the username to be edited when connecting to the workspace (only with Always ask password enabled).
Database	Enter the name of the Azure SQL database.
Test Database	Test the connection with the database to validate if the proper information has been provided.

Settings

OPTION	DESCRIPTION
Ping online method	Indicate the preferred ping online method. Select between: None Ping Port Scan
Automatically go offline on offline prompt	Use the workspace in offline mode when the ping method does not respond.

Upgrade

OPTION	DESCRIPTION
Test host	Check the connection to the database.
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.
Validate database	Validate the content of the database.
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 customer support team.

VPN

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

OPTION	DESCRIPTION
Type	Select between None or On first connect.
RDM File	Open a VPN entry type from a RDM file before connecting to the workspace.
Override credentials	Override credentials such as Username, Domain, and Password.

Advanced

OPTION	DESCRIPTION
Caching mode	Determines how the entries will be reloaded in the workspace. 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.
Trust certificate	Set how the workspace handles certificates.
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 workspace in offline mode when a user connects to the workspace.
Allow beta database upgrade	Allow beta upgrade of the database (when using a beta version of Remote Desktop Manager).
Manage Cache	Manage the workspace cache. On large workspaces, caching is a must and will increase performance significantly.
More Settings	Edit the connection string values directly.

macOS