Configurator/SQLConnection: Difference between revisions
Appearance
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
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.