> 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

Configure Advanced credentials in Devolutions Server Console to set the SQL accounts used by Management Tools, Scheduler Service, and the Web Application.

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](/server/knowledge-base/knowledge-base-articles/pre-deployment-account-survey.md).

### 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.devolutions.net/server/devolutions-server-console/devolutions-server-settings/database/advanced-credentials.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.