> 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/server/devolutions-server-console/devolutions-server-settings/database/advanced-credentials.md).

# Advanced credentials

The ***Advanced credentials*** are used to allow Devolutions Server to communicate with the SQL database.

{% hint style="warning" %}
Only SQL login accounts can be manually configured. With the ***Authentication type*** set to ***Windows Authentication*** the accounts are automatically pulled from the ***Scheduler Service*** and the IIS Application Pool Identity.
{% endhint %}

For further information about these accounts, please see [Pre-deployment account survey](https://docs.devolutions.net/server/kb/knowledge-base/pre-deployment-account-survey/).

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

### Settings

<table><thead><tr><th width="211">Option</th><th>Description</th></tr></thead><tbody><tr><td>Management Tools</td><td>Credentials that allow the Devolutions Server Console to communicate with the SQL database. Must be an SQL account.</td></tr><tr><td>Scheduler Service</td><td>Credentials used for the Scheduler Service features (Backup Manager, Email Notifications, Secure Messaging, Domain Users and User groups cache, Entra ID cache). Must be an SQL account. If the Integrated Security option is enabled, the Username and Password fields are grayed out.</td></tr><tr><td>Web Application</td><td>Credentials used for the Web Application to communicate with the SQL database. Must be an SQL account. If the Integrated Security option is enabled, the Username and Password fields are grayed out.</td></tr><tr><td>Test Connection</td><td>Test against the SQL server the credentials set in the Username/Password fields. If the Integrated Security option is enabled, the button is grayed out.</td></tr><tr><td>Apply Least Permissions</td><td>Will execute an SQL statement to grant least permissions on the database for the Scheduler Service or the Web Application accounts.</td></tr><tr><td>Generate Script</td><td>Will generate an SQL script that can be run on the SQL database for the Scheduler Service or the Web Application accounts. Only available with Windows Authentication.</td></tr></tbody></table>


---

# 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/server/devolutions-server-console/devolutions-server-settings/database/advanced-credentials.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.
Option	Description
Management Tools	Credentials that allow the Devolutions Server Console to communicate with the SQL database. Must be an SQL account.
Scheduler Service	Credentials used for the Scheduler Service features (Backup Manager, Email Notifications, Secure Messaging, Domain Users and User groups cache, Entra ID cache). Must be an SQL account. If the Integrated Security option is enabled, the Username and Password fields are grayed out.
Web Application	Credentials used for the Web Application to communicate with the SQL database. Must be an SQL account. If the Integrated Security option is enabled, the Username and Password fields are grayed out.
Test Connection	Test against the SQL server the credentials set in the Username/Password fields. If the Integrated Security option is enabled, the button is grayed out.
Apply Least Permissions	Will execute an SQL statement to grant least permissions on the database for the Scheduler Service or the Web Application accounts.
Generate Script	Will generate an SQL script that can be run on the SQL database for the Scheduler Service or the Web Application accounts. Only available with Windows Authentication.