Description
|
With the SQL Server data source, Remote Desktop Manager uses the power of Microsoft SQL Server to save and manage entries.
All editions of SQL Server (including Express) starting with 2012 and above are supported.
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 Offline Mode for when the server or network is unavailable.
•Supports full entry logs and attachments.
•Supports Repositories to organize thousands of entries.
|
A proper database backup strategy should be implemented to prevent possible data loss. Please refer to the Backups topic. |
|
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. |
|
Using either Database Login or Integrated Security is inheritely 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 the security conscious organizations will 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
OPTION |
DESCRIPTION |
|---|---|
Name |
Name the data source. |
Server |
Enter the server hostname or IP address. |
Ellipsis button |
Provides the list of computers discovered on your network. This can take a few moments to generate. |
Login mode |
Specify the authentication mode to use. Select between: •Database login •Custom login |
User |
Enter the username to access the SQL server. |
Password |
Enter the Password to access the SQL server. |
Database |
Enter the name of the database. |
Two factor |
Enable the 2-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
SQL Server - Settings Tab
OPTION |
DESCRIPTION |
|---|---|
Repository |
Click on the ellipsis to select a Repository. |
Root filter |
Enter the name of a root level folder to display only the entries contained in that folder. |
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 won't be prompted for the data source password if this option is disabled. |
Private Vault
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. |
Advanced
SQL Server - Advanced Tab
OPTION |
DESCRIPTION |
|---|---|
Caching mode |
Determines how the entries will be reloaded in the data source. For more information, please consult the Caching Mode topic. |
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. |
Connection timeout |
Set the delay of the connection timeout. |
Command timeout |
Set the delay of the command timeout. |
Allow beta database upgrade |
Allow beta upgrade of the database (when using a beta version of Remote Desktop Manager). |
Allow data source credential variables |
Allow the data source credential to be use in variables. |
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. |
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. |
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 the Devolutions support team. |
View Upgrade Script |
Open the upgrade script in a new window. |