Online Help > Data Sources > Data Source types > Advanced Data Source

SQL Server

Description

 

DataSourceSQLServerLarge

Remote Desktop Manager for Android 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

 

BadgeInfo48x48

You will be able to connect to a SQL server but you will not be able to create one. Your SQL Server data source has to be hosted on a desktop client like Windows or macOS to be able to create your data source.

 

BadgeWarning48x48

If a SSL certificate has been deployed on the SQL Server, it would not be possible for Remote Desktop Manager for Android to establish the connection to the database. SSL certificate on the SQL Server is not supported because of Mono, which is an application that we use in the development of Remote Desktop Manager for Android, doesn't support it. When they will support it, we will support it as well.

 

Create The Data Source

 

From the Data Sources section, tap on the Floating Action Button, then select the Microsoft SQL Server type.

 

Select data source type

Select data source type

 

Connection

SQL Server - Connection

SQL Server - Connection

 

Option

Description

Name

Enter the name of the data source.

Server

Enter the server hostname or IP address.

Login mode

Specify the authentication mode to use. Select between:

Database login

Integrated security

Custom login

User

Enter the username to access the SQL server.

Editable

Allows the User and Password fields to be left empty. Prompts the users for the credentials every time they connect to the data source.

Password

Enter the password to access the SQL server.

Save Password

Disable this option to prompt the users for the password every time they connect to the data source.

Database

Enter the name of the database.

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.

 

Private Vault

For more information, please consult the Private Vault topic.

 

Advanced

SQL Server - Advanced tab

SQL Server - Advanced tab

 

Option

Description

Offline mode

Allow the data source to be used in Offline mode. Select between:

Disabled: Do not allow offline mode.

Read-Only: Allow offline mode in read-only. Entries can be accessed offline but cannot be edited.

Auto go offline

If the ping online method doesn't work, the data source will automatically go offline.

Caching mode

Determine how entries are loaded from the data source. For more information, please consult the Caching Mode topic.

Repository

Select the data source repository, if using one.

Root filter

Enter the name of a root level folder to display only the entries contained in that folder.

Auto refresh

Set the time interval for the automatic refresh

Connection timeout

Set the waiting time before a connection timeout.

Command timeout

Set the waiting time before a command timeout.

Advanced Settings

Edit the connection string values manually.