Online Help > Data Sources > Data Source Types > Advanced Data Sources

SQL Server (MSSQL)

Description

 

DataSourceSQLServerLarge

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

 

SQL Server 2012, 2014 and 2016 are supported as well as SQL Server Express 2012, 2014 and 2016.

 

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.

Supports Repositories to organize thousands of entries.

 

BadgeWarning48x48

A proper database backup strategy should be implemented to minimize possible data loss, please refer to Backups topic.

 

BadgeWarning48x48

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

 

ShieldWarning48x48

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 would consider this unacceptable. It is recommended to use our Custom login model.

 

Configuration

 

Consult the Configure SQL Server topic 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 store.

SQL Server

Select your data source between the SQL Server or SQL Azure.

Login Mode

Specify the authentication mode to use. Select between:

Database login

Integrated Security

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

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 prefer 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 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 the Caching Mode topic.

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 to process Database upgrade by hand instead of automatically you may use the upgrade script to do so.

 

Private Vault

 

SQL Server - Private Vault tab

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