Ms sql odbc issue

Hello,

I need to connect to an external database (sql server 2016) i create a new datasource and i got an error :slight_smile:

The TCP/IP connection to the host mydbhostname port 1433 has failed. Error: “Connection refused: no further information. 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.”.

(With my CF server if leave blank the port and it works)

I’ve tried with Oracle driver it works

Thx for the help :slight_smile:

Marc

Hi @marcB,

Can you please check the MSSQL server running on TCP/IP enable. Look the screen shot here http://web.synametrics.com/sqlexpressremote.htm.

Please read thread below it may helps you.