Follow these instructions to create a new bootstrap file pointing to the existing database.
Solution 1: "Using configuration UI tool".
1). Login into the Spotfire server Machine.
2). Launch the 'TIBCO Spotfire Server Configuration Tool' by clicking Start > TIBCO Spotfire Server X.X > Configure TIBCO Spotfire Server OR by running uiconfig.bat (located in the <installation dir>\tomcat\spotfire-bin directory in version 10.3 and higher, <installation dir>\tomcat\bin in older versions).
3). Click Cancel on the Password dialogue. See the attached image (Filename: Bootstrap_Password.PNG).
4). This will take you to Configuration consoles' "System Status" tab.
5). Click on the 'Create new bootstrap file' link.
6). Enter the valid Spotfire server database, Database Name(SQL) or SID (ORCL), port number and user credentials to create a new bootstrap file. NOTE: If prompted, overwrite the existing bootstrap file.
Solution 2: "Using configuration commands":
1). Login into the Spotfire server machine and launch a terminal window/command prompt.
2). Browse to the <installation dir>\tomcat\spotfire-bin directory in version 10.3 and higher or <installation dir>\tomcat\bin if using an older version.
3). Run the following command to create a new bootstrap file.
config bootstrap -f --driver-class="<Driverclass Name>" --database-url="<Database URL>" --username="<DBusername>" --password="<DBpassword>" --tool-password="<New_tool_password>"
Note: Refer to section "Manually creating a simple configuration" in the Server Installation manual for more details.