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> .
The syntax for this variable is 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: |
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 .
|
Parent topic: Setting up the Spotfire database (SQL Server)