Avatar of crchisholm
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.
Web ServersMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Plucka
Avatar of erikTsomik
erikTsomik
Flag of United States of America image

have you tried to set it up with sa usrname
Avatar of Jones911
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
Avatar of Jones911
Jones911

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of Plucka
Plucka
Flag of Australia image

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
Microsoft SQL Server 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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo