Setting up the Spotfire database (SQL Server)
There are multiple ways to set up a SQL Server database server for storing the Spotfire database, as discussed in previous sections. This topic lists more information about some parameters you must provide, and detailed steps for setting up the database using the provided scripts.
About this task
To create and configure the Spotfire databases in a containerized environment, use the Cloud Deployment Kit for Spotfire on GitHub or the prebuilt container images.
To use the provided scripts to set up the database, follow the steps below.
Before you begin
- Download and unzip the Spotfire Server installation kit from the Spotfire Download site. For instructions, see Downloading installation software.
- You must have access to a SQL server database server.
- The following settings
must be configured on the SQL Server:
- TCP/IP communication listening on a port (the default is 1433).
- Case-insensitive
collation (at least for the
Spotfire
database).
Note: If your installation of SQL Server uses a case-sensitive collation by default, or your data uses a different collation than
Latin1_General_CI_AS
, you must edit the create_server_db.sql script before running the create_databases_ia.bat script. See Defining the SQL Server collation for details. - The command-line database tool sqlcmd must be installed in the system you are going to use to configure the database server.
Transaction (Process ID 68) was deadlocked on lock resources
with another process and has been chosen as the deadlock victim. Rerun the
transaction
, apply MVCC/Row versioning mode by using the setting
READ_COMMITTED_SNAPSHOT
.
Procedure
Results
The log file log.txt file is created in the working directory. If the execution should fail, then the log file contains information about the failure. If the execution succeeds, then information about the changes made to the database is available in the log file.