How do I manually create a SQL Server external database and where is it documented?
The following steps are described in the Installation and Setup Guide which can be found here.
Manual Database Configuration
If you chose the option Setup DB Later (manually) while installing the Management Server for use with an external database, you must manually configure the database prior to starting the Management Server by running the scripts in the \scripts\sql directory in the order shown below.
Note: The external database must exist before you run the scripts.
To perform manual database configuration:
1 Launch a command window.
2 Run the .sql scripts by issuing the following commands from the prompt in the order shown below.
Note In the commands shown below, replace and with the user name and password for the user account of the Microsoft SQL Server administrator.
**** Step a & b scripts must be run under an account with root privileges since you require system access to execute it.
a) sqlcmd -U -P -i \scripts\sql\sqlsvr_drop_db.sql
b) sqlcmd -U -P -i \scripts\sql\sqlsvr_create_db.sql
Note The script sqlsvr_create_db.sql does not drop the existing schema.
***** Step c & d scripts must be run using the Foglight Database Account User ID that you set in step 1 of Step 10: Foglight Database Configuration. The default Foglight Database Account User ID is 'foglight'.
c) sqlcmd -U -P -i \scripts\sql\sqlsvr_create_schema.sql
Note Warnings related to the maximum length of index keys appear. These warnings are safe to ignore.
d) sqlcmd -U -P -i \scripts\sql\sqlsvr_populate_db.sql
