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
-
Open the
mssql_install directory, and then open the
create_server_db.sql script in a text editor.
-
Locate the line
--create database $ (SPOTFIREDB_DBNAME) collate
Latin1_General_CI_AS;
-
Remove the leading dashes (
--
).
-
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.
-
Comment out the next line by inserting leading dashes (--), so
that the line looks like this:
--create database $(SPOTFIREDB_DBNAME)
-
Save the file.