The following error may be seen during a spotfire server installation, when creating a new spotfire database on SQL Server via the create_databases.(sh|bat)script.
Changed database context to 'master'.
Changed database context to 'spotfire_server'.
Msg 1911, Level 16, State 1, Server MYSQLSERVER\SPOTFIRE_DATABASE, Line 4
Column name 'activity_id' does not exist in the target table or view.
Msg 1750, Level 16, State 1, Server MYSQLSERVER\SPOTFIRE_DATABASE, Line 4
Could not create constraint or index. See previous errors
The reason for this error could be that the SQL server is using a case-sensitive collation by default. Check your SQL server for more information.
If this is the case a different collation needs to be used. Locate the following lines in the create_server_db.sql script.
Uncomment (remove leading dashses) the line that defines the collation in the create database statement, and comment out the line that uses create database without specifying collation. A different collation can be used, but it must be case-insensitive.
Save these changes and rerun the create_databases.(bat|sh) script. The script should now run without error.