Spotfire SQL Server enable TCP/IP

When creating the bootstrap for the first time, after your provide the details of your SQL server instance, you may run into an erro like below
"Error connecting to the specified data source. The TCP/IP connection to the host XXXX, port 1433  has failed.

This is most likely because your SQL server has not enabled the TCP/IP protocol.

Here are the steps to enable it.
Open SQL Server Configuration Manager from start menu

Expand the “SQL server network configuration”  and select protocol for “XXX” where XXX is your server instance name

Check if TCP/IP protocol is enabled. You can right click and enable it if it is not

After enabling right click and select properties, switch to IP Addresses Tab.

Scroll down to IPALL .

Change TCP portal to 1433 or other port as desired . Empty to Dynamic ports value if any present.

Hit Apply

Then restart the sql server services from the same panel or windows services panel