Spotfire® Server and Environment - Installation and Administration

Variables in create_databases (SQL Server)

Use these variables in the script for setting up a Spotfire database for SQL Server.

Variable Description
DBSERVER_CONNECTIDENTIFIER This variable is composed of the <DBSERVER_ADDRESS> (listed as <SERVER> in the script) and the <MSSQL_INSTANCENAME>.
  • Replace the script variable <SERVER> with the database server address of the server running the SQL Server instance.
  • Replace the script variable <MSSQL_INSTANCENAME> with the name of the SQL Server instance.

The syntax for this variable is DBSERVER_CONNECTIDENTIFIER = <DBSERVER_ADDRESS>\<MSSQL_INSTANCENAME>.

Note: The default installation of SQL Server creates an unnamed instance of the SQL Server. If your SQL Server is a new installation, delete the MSSQL_INSTANCENAME part of the line and enter only the database server address (for SERVER). This causes the connection to be made to the unnamed instance.
DBSERVER_ADMIN_USERNAME Name of a user with SQL database administrator privileges.

Default: sa.

DBSERVER_ADMIN_PASSWORD Password of the DBSERVER_ADMIN_USERNAME.
SPOTFIREDB_DBNAME Name of the Spotfire database that will be created.

Default: spotfire_server.

SPOTFIREDB_USERNAME Name of the user created to set up the Spotfire database.

Example: spotfire

SPOTFIREDB_PASSWORD Password for SPOTFIREDB_USERNAME.