Skip to main content
V
VladL_
Known Participant
April 20, 2009
Question

Error access CF8 to Microsoft SQL Server 2008

  • April 20, 2009
  • 1 reply
  • 1694 views

Hello!

I have created a database in SQL Server 2008.

Further, in CF Administrator Add New Data Source - also there is an error.

Connection verification failed for data source:  dbo.Articles

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error  establishing socket to host and port: localhost:1433. Reason: Connection  refused: connect
The root cause was that: java.sql.SQLException:  [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port:  localhost:1433. Reason: Connection refused: connect

Prompt how to solve this problem?

This topic has been closed for replies.

1 reply

L
Libby_H
Inspiring
April 22, 2009

What type of authentication do you use on the SQL Server database?  If you use 'SQL Server and Windows', did you use this id/password in setting up the Data Source within ColdFusion Administrator?

V
VladL_Author
Known Participant
April 22, 2009

Libby H Yes, I used Administrator CF, I already managed to solve this problem. The Server field I has installed the empty...

Also I have customised TCP/IP in the Manager of configuration SQL Server 2008 - all TCP-port have assigned value 1433

A
Anonymous
July 1, 2009

What is the solution?

I have the same thing with SQL Server 2008 64 bit. When i switch my datasource from SQL 2008 to SQL 2000 it works great otherwise it will not work. I have checked SQL Server 2008 that all the ports show 1433. I have been stuck on this for a while. I also checked the SQL Server Network Configuration / TCP/IP and i have nothing in the dynamic field and all the ports show 1433. If someone has allready figured this out it would be good to have a solution- Especially since coldfusion is supposed to connect to the database....

Thanks for any help.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices