DSN verification error

Communities CommandBox CLI
1

I am setting up a new laptop and want to have the minimum installed to do my CF development. I have SQL Server Express and CommandBox installed. I’m still getting this error when setting up a datasource:

Connection verification failed for data source: FileLibrary
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect

All my googling has just told me to ensure TCP/IP is enabled (a la https://helpx.adobe.com/coldfusion/kb/configuring-sql-server-express-default.html), and it is. I’ve checked my settings against my old laptop, which also is running MSSQL and CB, and can’t find a difference. I’m stuck at what else to try. I know this might not be an issue directly related to CB. Please help!

2

I think this is more of a SQL Server question, than a CommandBox one. It sounds like you don’t have TCP/IP enabled and the proper port set. I would review those settings. There’s several pieces that have to be in place for it to work on SQL Server Express.

Thanks!

~Brad

Developer Advocate
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

3

Thank you, Brad! I thought I had tried everything and was down to it being some config issue in Commandbox, so I posted here. Turns out the port was blank on my last entry in the IP Address tab in SQL Config Manager. I’m up and running now! Thank again!