Configurator/SQLConnection: Difference between revisions
Created page with "none|frame" |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[File:SQLConnection.jpg|none|frame]] | This setting allow you to specify the SQL Server connection information. | ||
This is found in Configurator under Setttings -> SQL Connection[[File:SQLConnection.jpg|none|frame]] | |||
=== 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. | |||
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.