Spotfire Server: Unable to save server configuration to the Spotfire Server's SQL Server database

Unable to save Spotfire Server configuration to the Spotfire Server's MS SQL Server database.

You may come across below error in Spotfire Server logs (server.log) while saving Spotfire Server configuration to its SQL Server database:

-------------
WARN 2018-02-14T17:36:49,770+0100 config.tool.ConfigApp: Error executing command import-config
com.spotfire.server.config.tool.CommandException: Error importing the new server configuration to the database: Unable to save configuration
    at com.spotfire.server.config.tool.ImportCommand.run(ImportCommand.java:172) ~[server.jar:?]   
    at com.spotfire.server.config.tool.ConfigApp.executeCommand(ConfigApp.java:369) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp.access$400(ConfigApp.java:50) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp$RunScriptCommand.run(ConfigApp.java:627) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp.executeCommand(ConfigApp.java:369) [server.jar:?]
    at com.spotfire.server.config.tool.ConfigApp.main(ConfigApp.java:458) [server.jar:?]
Caused by: com.spotfire.server.config.ConfigurationException: Unable to save configuration
     at com.spotfire.server.config.DatabaseConfigurationProvider.insertConfigurationMSSQL(DatabaseConfigurationProvider.java:463) ~[server.jar:?]
     at com.spotfire.server.config.DatabaseConfigurationProvider.saveConfiguration(DatabaseConfigurationProvider.java:361) ~[server.jar:?]
     at com.spotfire.server.config.DatabaseConfigurationProvider.saveConfiguration(DatabaseConfigurationProvider.java:302) ~[server.jar:?]
     at com.spotfire.server.config.tool.ImportCommand.run(ImportCommand.java:145) ~[server.jar:?]
     ... 5 more

Caused by: java.sql.SQLDataException: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.
-------------

Translation : Converting a varchar data type to a datetime datatype has created a value out of bounds.

This error generally comes when the Default language of Spotfire Server's database user (Database user mentioned in the bootstrap.xml file) set to some different language other than "US-English".

To resolve this issue, perform below steps for the Database user mentioned in the bootstrap.xml file. Change the Default language of Spotfire DB user to "US-English" using SQL Server Management Studio:

Steps:
- Connect to SQL Server using DB Administrator user account e.g 'SA' account.
- Select the Spotfire DB user and Right click.
- Select properties-> Default language settings.
- Select ”English” from drop-down menu and click OK.
- Restart the Spotfire Server service.