Jump to content

Configurator/SQLConnection

From UmsWiki

This setting allow you to specify the SQL Server connection information.

This is found in Configurator under Setttings -> SQL Connection

Server name

SQL Server name.

Database name

Database name that exists on the SQL Server.

Encrypt

Enable encryption when communication with the SQL Server.

Trust server certificate

https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnectionstringbuilder.trustservercertificate?view=net-9.0-pp

Use Windows authentication

This can be used, except for the password agents. But SQL authentication is recommended.

Use SQL Server authentication

A SQL user must exist that has owner access to the database.

User ID

SQL username.

Password

SQL password.