Run the script for SQL Server interactively

If you are a new administrator and are creating only one Spotfire database, then this option of running the database configuration interactively, providing the values at the prompts, might best suit your scenario.

Before you begin

Complete the requirements and steps described in Preparing the SQL Server database for Spotfire.

Procedure

Copy the <installation files dir>/scripts/mssql_install directory to a location where you can edit it.
This directory contains script files that correspond to supported platforms. The file to edit depends on your platform.
- Linux: create_databases.sh
- Windows: create_databases.bat
- Linux (SQL Server running on Amazon RDS): create_databases_rds.sh
- Windows (SQL Server running on Amazon RDS): create_databases_rds.bat
Configure the following settings on the SQL server database computer.
- 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.bat script.
Optional: If your installation of SQL Server uses a case-sensitive collation by default, or if you need to define a different collation, follow these steps:
1. On the SQL Server computer, open the mssql_install directory, and then open the create_server_db.sql script in a text editor.
2. Locate the line --create database $ (SPOTFIREDB_DBNAME) collate Latin1_General_CI_AS;
3. Remove the leading dashes (--).
4. If needed, replace Latin1_General_CI_AS with the name of the desired collation, but make sure it is case-insensitive (CI). See the SQL Server documentation for information about available collations.
5. Comment out the next line by inserting leading dashes (--), so that the line looks like this: --create database $(SPOTFIREDB_DBNAME)
6. Save the file and close the text editor.

Run the script for your platform, and provide the values for the parameters as you are prompted.

For more information about the variables, see Variables in create_databases (SQL Server).

When you have provided valid values for each of the prompts, a confirmation message similar to the following example is displayed.

You have supplied the following information:
DBSERVER_CONNECTIDENTIFIER:      192.168.56.4\SQLEXPRESS
DBSERVER_ADMIN_USERNAME:         sa
DBSERVER_ADMIN_PASSWORD:         *********
SPOTFIREDB_DBNAME:               spot_server_win_vars
SPOTFIREDB_USERNAME:             new_vars
SPOTFIREDB_PASSWORD:             *********

Would you like to use the above information to create the spotfire server database? [y/n]:

Press y to confirm.

Results

The required Spotfire user and database table schemas are created in your database.

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.

What to do next

Install Spotfire Server