I just installed SQL Server 2008 R2 and ColdFusion 9.0.1 on my Windows 7 machine for development use only.
I have ColdFusion running well and serving pages (that aren't connected to a database). I can view my databases in SQL Server Management Studio.
I successfully restored a few small databases and now I am trying to set up datasources for them through the ColdFusion Administrator. On my other machine, this was super easy. Not so much this time.
The database I just added is named "Test".
I am getting this error:
Connection verification failed for data source: Test
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
It looks like the connection between ColdFusion and SQL Server is being refused. I know, brilliant observation, right?
On my other machine, I was able to create datasources with just the default settings, no server name, username, or password.
Any clue as to what might be the cause and how I might fix it?