Setting up remote sql server 2005 access with coldfusion

[ice78991]

I have been experimenting with settng up a remote sql server.

My router has assigned my pc an ip of 10.0.0.29

In the Coldfusion Administrator section I have swapped in this address for my previous localhost address 127.0.0.1 which worked fine

When I submit these changes I get the following error.

How should I be attempting to connect to a remote sql server?



Connection verification failed for data source: CLASSDSN
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect

 

[ice78991]

I'm running sql server 2005

 

[mrdenny]

Have you told SQL 2005 to listen for remote connections?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ice78991]

I have enabled remote connections for TCP and pipes

I have checked the IP address that my router gave me in the router's info page and it is correct.

Getting the same error in Coldfusion Administrator

Connection verification failed for data source: CLASSDSN
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect

 

[Catadmin]

Have you checked for firewalls or other things that might be blocking port access to SQL from ColdFusion?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ice78991]

I have ensured that the firewalls are not the problem. The only thing I should mention is that the IP address 10.0.0.29
is the address that the router has given my PC and SQL server resides on the same machine ( ie 127.0.0.1 and 10.0.0.9 are the same machine)

Could this be the problem ?

 

[Catadmin]

I doubt it. I've never seen that type of problem occur before with other applications. But then I've never used ColdFusion before.

Double-check the login has been granted the ability to connect to your Database, that its default database still exists and that it has more than "public" permissions in the DB.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Here is an FAQ on checking that the connection works correctly faq962-5481.

What are the answers to the questions asked?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com