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
Article ID: KB0081889
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All supported versions |
Description
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
****************************
****************************
[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
****************************
Issue/Introduction
Bootstrap creation may result in the error "[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".
Resolution
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:
Here is a sample screenshot that explains this workaround:
Feedback
Yes
No
Powered by
