crchisholm
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.
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
On SQL Express you have to enable TCP/IP and set the port to 1433 by defualt its not turned on
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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