Bootstrap creation may result in "[tibcosoftwareinc][SQLServer JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets" error

Bootstrap creation may result in "[tibcosoftwareinc][SQLServer JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets" error

Creating a bootstrap file via "Spotfire Server Configuration Tool" may result in the following error when using an "MS SQLServer Named Instance" for Spotfire Database.

****************************
[tibcosoftwareinc][SQLServer JDBC Driver]Unable to connect.  Invalid URL.  If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets.
Ex:jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:5000;databaseName=DBNAME
**************************** Port Number is a required field in the Spotfire Server Configuration Tool to enable the "Save Bootstrap" button, even though there is no assigned port number for MS SQLServer named instances. To resolve this behavior, enter "any" port number in the "Port" field but manually delete this number from the "Connection URL".

Here is a sample screenshot that explains this workaround: