Microsoft SQL Server offline mode

Follow the steps to lean how to enable offline mode for a Microsoft SQL Server workspace.

Some features of Remote Desktop Manager are unavailable while offline. Even with the read/write access mode, you may not be able to perform all actions, such as adding attachments or managing users, since these features are not cached locally. On the other hand, the user vault is still available in offline mode.

Configuration

1. Open Remote Desktop Manager.
2. Go to the Properties of the workspace.
3. Click Edit workspace and navigate to the Advanced tab.
4. Select In-memory or File in the Caching mode drop-down menu.
5. Click Save to close the window.

This step cannot be modified remotely once you have exported your workspace settings

OPTION	DESCRIPTION
Disabled	Prevents offline cache from being used.
In-memory	Uses the offline cache only for recent changes, but prevents it from writing on the disk
File	Uses the offline cache only for recent changes. The cache will write on the disk.

1. Go to the ribbon of Remote Desktop Manager.
2. Select Administration – System settings – Cache/Offline, and set Offline mode to Cache-only, Read-only or Read/write.
3. Click Save to close the window.

   

OPTION	DESCRIPTION
Disabled	Prevents an offline cache from being used.
Cache only	Allows to save a cache of the workspace in order to improve loading performance. This option disallows the use of the offline mode.
Read-only	Allows to view and use entries only. The content of the workspace cannot be modified.
Read/Write	Allows to view, use, and edit entries. Conflicts caused by offline modifications are managed when back online.

Vault settings

1. For each vault, go to Administration – Vault settings – Security settings, and set Allow offline to Yes.
2. Click Update to save and close the window.

User account offline mode setting

To enable a user account to use offline mode, go to Administration – Users – Edit – Settings, and set the Offline mode setting to Cache-only, Read-only or Read/write.

A user must be granted Read/Write at all levels to allow read/write privileges.

Workspace information

To have a overview of the workspace configuration, open the Workspace information by going to File - My workspace information in Remote Desktop Manager. It displays the size of the offline cache file along with the effective modes.

Going offline

Remote Desktop Manager will prompt for offline mode when the application is unable to reach the workspace. The offline mode can also be toggled manually via File – Go offline or by clicking the Go offline button located in the bottom pane.

Grant and deny offline

A user must be granted Read/Write at all levels to allow read/write privileges. Here is a table recapitulating all the settings/permissions along with the effective access they grant:

USER PERMISSIONS	SYSTEM SETTINGS	VAULT SETTINGS	EFFECTIVE ACCESS
Disabled or Read-only or Read/write	Disabled or Read-only or Read/write	Allow offline disabled	Disabled
Disabled or Read-only or Read/write	Disabled or Read-only or Read/write	Allow offline enabled	Disabled
Disabled or Read-only or Read/write	Disabled	Allow offline enabled	Disabled
Disabled	Disabled or Read-only or Read/write	Allow offline enabled	Disabled
Read-only or Read/write	Read-only or Read/write	Allow offline disabled	Disabled
Read-only or Read/write	Read-only or Read/write	Allow offline enabled	Read-only
Read-only or Read/write	Read-only	Allow offline enabled	Read-only
Read-only	Read-only or Read/write	Allow offline enabled	Read-only
Read/write	Read/write	Allow offline enabled	Read/write