> For the complete documentation index, see [llms.txt](https://docs.devolutions.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.devolutions.net/rdm/workspaces/offline-mode/microsoft-sql-server-offline-mode.md).

# Microsoft SQL Server offline mode

Follow the steps to lean how to enable [offline mode](https://docs.devolutions.net/rdm/workspaces/offline-mode/) for a [Microsoft SQL Server workspace](https://docs.devolutions.net/rdm/workspaces/workspace-types/native-workspaces/microsoft-sql-server/configure/).

{% hint style="info" %}
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.
{% endhint %}

### 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

![](https://cdnweb.devolutions.net/docs/RDMW6030_2024_3.png)

<table data-header-hidden><thead><tr><th width="138"></th><th></th></tr></thead><tbody><tr><td><strong>OPTION</strong></td><td><strong>DESCRIPTION</strong></td></tr><tr><td><strong>Disabled</strong></td><td>Prevents offline cache from being used.</td></tr><tr><td><strong>In-memory</strong></td><td>Uses the offline cache only for recent changes, but prevents it from writing on the disk</td></tr><tr><td><strong>File</strong></td><td>Uses the offline cache only for recent changes. The cache will write on the disk.</td></tr></tbody></table>

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

   <figure><img src="https://cdnweb.devolutions.net/docs/image.png" alt=""><figcaption></figcaption></figure>

<table data-header-hidden><thead><tr><th width="146"></th><th></th></tr></thead><tbody><tr><td><strong>OPTION</strong></td><td><strong>DESCRIPTION</strong></td></tr><tr><td><strong>Disabled</strong></td><td>Prevents an offline cache from being used.</td></tr><tr><td><strong>Cache only</strong></td><td>Allows to save a cache of the workspace in order to improve loading performance. This option disallows the use of the offline mode.</td></tr><tr><td><strong>Read-only</strong></td><td>Allows to view and use entries only. The content of the workspace cannot be modified.</td></tr><tr><td><a href="https://docs.devolutions.net/rdm/workspaces/offline-mode/offline-read-write/"><strong>Read/Write</strong></a></td><td>Allows to view, use, and edit entries. Conflicts caused by offline modifications are managed when back online.</td></tr></tbody></table>

#### 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.

![](https://cdnweb.devolutions.net/docs/RDMW4086_2024_2.png)

#### 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***.<br>

<figure><img src="https://cdnweb.devolutions.net/docs/RDMW4088_2024_2.png" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
A user must be granted [Read/Write at all levels](#Grant-and-deny-offline) to allow read/write privileges.
{% endhint %}

#### Workspace information

To have a overview of the workspace configuration, open the [Workspace information](https://docs.devolutions.net/rdm/commands/file/my-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           |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.devolutions.net/rdm/workspaces/offline-mode/microsoft-sql-server-offline-mode.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.