How do I resolve errors when seeding the SSC database

Question

I am setting up Fortify SSC and receiving errors when seeding the database. How do I resolve these errors?

Answer

The most common cause for issues when seeding the SSC database is the case sensitivity of the database. Fortify SSC requires that the database be set up to support case-sensitive collations, however SQL Server sets collations to be case-insensitive by default. To resolve this issue, the database tables will need to be removed and the database recreated to support case-sensitive collations.

The following provides information on setting the collations to be case-sensitive. This step must be done before running the create-tables.sql file that is provided with the SSC distribution.

MS SQL Server

After logging into the SQL Server Management Studio and creating a new database for Fortify, select “Options” in the panel on the left and set the collation to “SQL_Latin1_General_CP1_CS_AS” as pictured below:

References

Fortify SSC User’s Guide Installing SSC 19.2.0 with MySQL 8.0 in Easy Steps on Windows 2016 Installing SSC 19.2.0 with MSSQL 2017 in Easy Steps on Windows 2016