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 Configuring SQL Server Express to use TCP/IP for remote connections with ODBC.

Please read thread below it may helps you.
https://lucee.daemonite.io/t/odbc-datasource-from-lucee/1712/15