Spotfire® Server and Environment - Installation and Administration

Defining the SQL Server collation

If your installation of SQL Server uses a case-sensitive collation by default, or if you need to define a different collation, follow these steps before you set up the Spotfire database.

Procedure

  1. Open the mssql_install directory, and then open the create_server_db.sql script in a text editor.
  2. Locate the line --create database $ (SPOTFIREDB_DBNAME) collate Latin1_General_CI_AS;
  3. Remove the leading dashes (--).
  4. If needed, replace Latin1_General_CI_AS with the name of the desired collation, but make sure it is case-insensitive (CI). See the SQL Server documentation for information about available collations.
  5. Comment out the next line by inserting leading dashes (--), so that the line looks like this:
    --create database $(SPOTFIREDB_DBNAME)
  6. Save the file.