Unable to connect to SQL Server via TIBCO Spotfire Information Designer
I am trying to connect to SQL Server DB via Infromation Designer(set up data source) but it is throwing the below error The TCP/IP connection to the host , 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." But i am able to connect through SQL Server Management Studio (which is installed in different machine). Also i tried connecting to different DB Server of SQL database and that is successful. Please let me know any configuration needs to be done from Spotfire end.
Go to the Windows start -> All Programs -> Sql Server Configuration Manager on your desktop. Expand the SQL Server Network Configuration option and select Protols for MSSQLSERVER. Verify that TCIP/IP is enabled in the panel on the right.
Add SSL if require, Also check if login is User-id/password not windows authentication on SQL server. And Firewall open for Spot-fire host.
Also, if that particular SQL server requires SSL you will have to force that in the connection string.