Search

Your Notifications (0)

There are currently no notifications. You're all set!

Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Unable to create a bootstrap file for Microsoft SQL Server hosted on Amazon RDS(Relational Database Services) instance.

Krauss, Donald
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Unable to create a bootstrap file for Microsoft SQL Server hosted on Amazon RDS(Relational Database Services) instance.


Solution:


When you try to create a bootstrap connection between Spotfire Server and  Microsoft SQL Server hosted on Amazon RDS instance, it may fail with the following error message:
----------------------------
There was an error connecting to the Spotfire Server database:  The TCP/IP connection to the host xxxx, port 1433 has failed. 

Error:  “Connection refused:  connect.  Verify the connection properties.  Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port.  Make sure that TCP connections to the port are not blocked by a firewall.
----------------------------

  Make sure you are using Amazon RDS endpoint in the hostname details and not the "localhost" or the name of the server on which SQL Server Management Studio resides.

Note:  You may want to check if the security groups for each instance has the required permissions on the TCP ports.

Related articles

Comments

0 comments

Article is closed for comments.