Create an empty relational database on the installed SQL Server instance. Give it a proper name i.e. TARGITLogDB.
Create an Auxiliary Relational Database connection in TARGIT Management client.
This is done using the Connections tab à right-click in the working area and add a connection à click ‘Other’ à click ‘Auxiliary Relational Database’.
Specify a proper name for the connection, i.e. LogDB. – on the next screen a connection string needs to be specified. Click ‘Change connection string’.
Select the desired provider. In this case we will be using the ‘SQL Server Native 10.0’ provider to connect to the relational database we created earlier.
Now, click ‘Next’ to configure the connection and database. In our case, the database is hosted on the local installed SQL Server instance, so we simply refer to the server: ‘Localhost’.
We can connect to the server using Windows integrated security. This setting also needs to be applied. Finally, the database we will be using needs to be selected from the list. Click ‘OK’ to create the connection string.
Click ‘Create’ to finish configuration of the Auxiliary connection.