Configuring Database

Cygna Auditor feeds collected data to the SQL Server database. On this step, configure connection settings and provide access to the database.

FIELD

DESCRIPTION

Enter connection information

SQL Server instance name

Select the SQL Server instance name from the list or input it in one of the following formats: hostname\instance (e.g., DemoSQL\SQL16) or hostname,port (e.g., DemoSQL,1833).

Cygna Labs recommends using Standard or Enterprise edition of SQL Server. Express edition is only suitable for evaluation purposes and requires additional configuration steps. For more information, see Configuring Additional Steps for SQL Server Express.

Use Windows authentication

Use SQL Server authentication

Account, password

Specify the authentication type and enter credentials.

Note: SQL authentication is a recommended method. If you select Windows authentication method, the user who runs the installation will be used to access SQL Server. Make sure this Windows account has all the necessary roles on the SQL Server instance and also make sure to check out the Post-Installation Steps.

Connection timeout

Connection retry count

Connection retry interval

By default, the connection fails if the response time exceeds 15 seconds, Cygna Auditor will attempt to reconnect once after 10 seconds. You can update these settings and set another retry count or timeout time if your network is prone to connectivity issues.
Verify connection information

Click the button to check if the account you specified has sufficient permissions on your SQL Server instance. See Account and Permissions Checklist for more information about server and database roles required.

Configure database

Database name

Select existing or new database to store audit data.

Note: You can leverage an existing database if you used it to store Cygna Auditor data before and want to have access to collected audit data. Since Cygna Auditor will modify the database, specifying the databases employed by other applications is not advised.

Save connection string

Review database connection settings and save them.