Jump to content

Configurator/SQLConnection: Difference between revisions

From UmsWiki
No edit summary
No edit summary
 
Line 11: Line 11:
=== Encrypt ===
=== Encrypt ===
Enable encryption when communication with the SQL Server.
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 ===
=== Use Windows authentication ===

Latest revision as of 06:40, 15 July 2025

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.