Use environment variables to set up the Spotfire database for SQL Server
If you are installing a cluster and setting up multiple database servers, then this option of creating environment variables for the Spotfire database script might best suit your installation scenario.
About this task
For example, if you are an experienced script author and experienced with setting up multiple database servers, then you can modify just DBSERVER_CONNECTIDENTIFIER
for every new database server and specify the environment variable values for all other settings.
Perform this task before installing Spotfire Server.
Before you begin
Complete the requirements and steps described in Setting up the Spotfire database (SQL Server).
Procedure
Results
The log file log.txt file is created in the working directory. If the execution fails, then the log file contains information about the failure. If the execution succeeds, then information about changes to the database (such as Tablespace created, User created, and so on) are reflected in the log file.