Configuration Notes for SQL Server

To be able to use SourceIQ with a SQL database you need to ensure that the SourceIQ server has permissions to access the database. For best results configure the SQL server group with Mixed Authentication Mode and use an sql user with appropriate permissions and a known password.

To Configure the SQL Server Group with Mixed Authentication:

1. Highlight the SQL server group (example: local)
2. Right-click and select "Properties"
3. Go to the Security Tab
4. Under "Authentication" select the "SQL Server and Windows" radio button
5. Click "OK"

The SourceIQ server uses JBoss to connect to the SQL Server Database. Needs to be configured with the username and password it will use to access the SQL Server Database. You can use either the default SQL Server "sa" user or have your DBA create a SQL server user with appropriate read/write/execute permissions to the database and a known password. The username and password will be hardcoded into the JBoss configuration file: JBOSS_HOME\server\default\deploy\mssql-ds.xml

Additional Configuration for the SCPM Database

Once the SCPM database is created, the Recovery setting needs to be set to the "Simple" model. Follow these steps to configure the Recovery mode:

1. Navigate to the SCPM database
2. Highlight the SCPM database and right-click
3. Select "Properties" 
4. Go to the "Options" tab
5. In the middle of the window is a Recovery section, select "Simple" from the drop-down menu
6. Click "OK"