Check Database Collation Sequence

All databases for this system require the correct collation sequence, both case insensitive and accent sensitive.

This is easiest if they are installed on one or more database instances that have this as the default collation sequence. If you are carrying forward the database instance that previously supported yourFlexNet Manager Suite implementation, this already complies with the appropriate collations sequence. For any new DB instance, use this process to check the collation sequence.

To validate the server's default database collation sequence:

  1. In SQL Server Management Studio, locate the SQL Server instance in the Object Explorer pane.
  2. Right-click the server, and select Properties from the context menu.
  3. On the server Properties dialog, select the General tab, and check the current collation sequence.
    If the collation sequence includes the codes _CI_AS (for example, SQL_Latin1_General_CP1_CI_AS), you may proceed with the installation.
    Tip: Other suffixes like _KS or _WS are optional.
    If the server's default collation does not include _CI_AS, you can set the collation sequence for each database, as you create it, by right-clicking the new database, selecting Properties from the context menu, and choosing the collation on the Options tab. Remember that the collation sequence must be identical for:
    • The compliance database (suggested name: FNMSCompliance)
    • The reporting snapshot database (suggested: FNMSSnapshot)
    • The data warehouse database (suggested: FNMSDataWarehouse).
    For example, if the first of these has the collation sequence called SQL_Latin1_General_CP1_CI_AS, then all of them must have the exact same collation sequence. In contrast, the inventory database, when separate (suggested: FNMSInventory), and the Cognos content store may have different collation sequences, provided that these also include the same _CI_AS codes. The tempdb database (alone) may have any collation sequence, since FlexNet Manager Suite creates the required tables here with the appropriate collation sequence.