SQL Configuration in Workbench

GENESIS uses Microsoft SQL Server for storing and managing project configuration and data. It supports several authentication methods with trusted certificates and encrypted connection.

• Windows NT Integrated Security: Uses the identity of the ICONICS Databases Point Manager service to authenticate to the SQL Server. By default, the service is configured to log in as NT AUTHORITY\NETWORK SERVICE.
• SQL Security: Uses an explicit SQL Server user account. It requires a SQL Server account with the permission to log in to SQL Server and connect to the desired databases.
• Azure Active Directory (AAD) Integrated Security: Uses the Azure Active Directory to identify the ICONICS Databases Point Manager service account to authenticate to the SQL Server.
• Azure Active Directory (AAD) Security: Uses an explicit Azure Active Directory user account. It requires an Azure SQL Server account with permission to log in to Azure SQL and connect to the desired databases.

You can view, add, remove, and edit SQL Server instances in Workbench using SQL Configuration on the Project ribbon. In addition, it allows you to import available SQL Server instances from the network and test the connection with the listed servers.

You can also use the Configure System utility to set up the connection to the SQL Server, especially after a new installation. Learn more