SQL Server Configuration Overview
GENESIS uses Microsoft SQL Server for storing and managing project configuration and data. The SQL Server supports the following 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.
- Entra ID Security: Uses an explicit Microsoft Entra ID 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
What's Next?