Configurator/SQLConnection

From UmsWiki
Jump to navigation Jump to search

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.

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.