asked on

coldfusion 8 not connecting to SQL 2005

I am having a problem setting up a development environment on my lap top. I have MSSQL 2005 and coldfusion 8 (developer) installed and when I try to setup a data source to a database named ATC, I get....

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

The SQL instance is the default instance and I am referencing it by the machine name GW03828 and wondered if there might be a problem with that. I also created a login that I know had all the necessary permissions and this failed as did SA.

erikTsomik

have you tried to set it up with sa usrname

Jones911

On SQL Express you have to enable TCP/IP and set the port to 1433 by defualt its not turned on

ASKER CERTIFIED SOLUTION

Jones911

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Plucka

By default SQL 2005 doesn't have TCP/IP enabled and working on 1433

There are several turorials out there on how to enable this, but in summary enable TCP/IP and make it use port 1433
Have a look at this one
http://www.mattwoodward.com/blog/index.cfm?event=showEntry&entryID=01930619-FD0A-4F02-31B1BFC7D1D9A44C

or google, ColdFusion & SQL 2005