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?