> 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/knowledge-base/how-to-articles/sql-server-workspace-with-integrated-security.md).

# SQL Server workspace with integrated security

We will take you through a step by step guide to configure and test a Remote Desktop Manager deployment against an SQL Server workspace using Integrated Security.

{% hint style="danger" %}
Any user (domain, local machine or SQL user) that has a server role of ***sysadmin*** is automatically an administrator of Remote Desktop Manager
{% endhint %}

### Create the database

The first step is to create the database that will store all your entries.

Click on the ***ellipsis*** button in the ***navigation pane***, then click on ***Add a new workspace***.

Select the ***Microsoft SQL Server*** workspace and click ***OK***.

* Specify the ***Name, Server*** and ***Database***.
* Authenticate with a user that is part of the ***sysadmin*** role.

  <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>If the logged-on Windows User is not part of the SQL Server <em><strong>sysadmin</strong></em> role and you have configured the server to use SQL Server and Windows Authentication Mode, then use an SQL Server user (SA for example) that has the appropriate user groups assigned. You can then add yourself as a Remote Desktop Manager user later and change the workspace to use Integrated security.</p></div>
* From the upgrade tab, click ***Test Server*** then ***Create Database*** to create the SQL Server database.

Press ***OK*** to close the dialogs. In the ***navigation pane***, select the newly created workspace from the workspace drop down list.

### Create users

To create users, navigate to ***Administration – Users***.

Click ***Add Users***.

Check the ***Integrated security (Active Directory)*** box and click the ellipsis button to select the domain user to add.

Select the ***User type*** Grant the ***Add***, ***Edit***, and ***Delete*** rights (optional, restricted user only). For more information on user types and rights, please consult [User Management](https://docs.devolutions.net/rdm/commands/administration/user-management/).

{% hint style="info" %}
Keep the ***Create SQL Server Login and User*** box checked. This will in effect cause Remote Desktop Manager to map a new login to the domain account and link it to a user.You can uncheck this in the case where your DBA has created your login already on the SQL Server.
{% endhint %}

Repeat these steps for each user that needs access to this workspace in Remote Desktop Manager.

### Configure Remote Desktop Manager for other workstations

To configure the workspace on other workstations, three methods are available:

* Create the workspace as done previously, making sure to check the ***Integrated Security (Active Directory)*** box.
* Export the workspace from the initial workstation and import it into Remote Desktop Manager on all client workstations.
* Use our [custom installer manager](https://docs.devolutions.net/rdm/installation/client/custom-installer-service/) service to help distribute the application and personalize the installation process.

### Test the configuration

If you have a second set of domain credentials, you could use this trick to test locally. [Running Remote Desktop Manager as Another User](https://docs.devolutions.net/rdm/kb/how-to-articles/running-rdm-as-another-user/)

Now in your Remote Desktop Manager with admin rights, create a few user groups (Admin, Production, Staging) and assign them users.


---

# 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/knowledge-base/how-to-articles/sql-server-workspace-with-integrated-security.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.