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.
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
