Microsoft SQL Azure

Description

 

With the Microsoft SQL Azure data source, 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 Azure SQL Database for RDM

 

Microsoft SQL Azure offers different service tier in their 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.

Used to create an online database. Get more information on Microsoft SQL Azure.

 

For Azure AD authentication, download and install the “Microsoft Active Directory Authentication Library for Microsoft SQL Server“.

 

Please download it here : https://www.microsoft.com/en-us/download/details.aspx?id=48742.

A proper database backup strategy should be implemented to prevent possible data loss. Please refer to the Backups topic.

 

 

Configuration

 

Consult the Configure SQL Azure topic for more information on the configuration.

 

Settings

 

General

Microsoft SQL Azure - General

Microsoft SQL Azure - General

 

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

Custom login

Active Directory Password

Active Directory Integrated

Active Directory Interactive (with MFA support)

Username

Enter the username to access the SQL Azure database.

Password

Enter the password to access the SQL Azure 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 SQL Azure database.

Two factor

Enable the 2-Factor Authentication.

Test Database

Test the connection with the database to validate if the proper information has been provided.

 

Settings

Microsoft SQL Azure - Settings Tab

Microsoft SQL Azure - 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 won't be prompted for the data source password if this option is disabled.

 

Private Vault

Microsoft SQL Azure - Private Vault Tab

Microsoft SQL Azure - Private Vault Tab

 

OPTION

DESCRIPTION

Type

Select the type of Private Vault to use. Select between:

Default: use the default Private Vault, which is stored in the database.

None: disable the Private Vault for all users.

Online Drive: use a Devolutions Online Drive file (*.dod) as a Private Vault.

 

Upgrade

Microsoft SQL Azure - Upgrade Tab

Microsoft SQL Azure - Upgrade Tab

 

OPTION

DESCRIPTION

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.

Email Schema to Support

Send your schema to the Devolutions Support team.

View Upgrade Script

Prompts a window to provide information about the Upgrade Script.

 

VPN

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

 

Microsoft SQL Azure - VPN

Microsoft SQL Azure - VPN

 

Advanced

Microsoft SQL Azure - Advanced Tab

Microsoft SQL Azure - Advanced Tab

 

OPTION

DESCRIPTION

Caching mode

Determines how the entries will be reloaded in the data source. For more information, please consult the Caching topic.

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 a 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 the Manage Cache topic.

More Settings

Edit the connection string values directly.