Skip to main content
K
kodemonki
Inspiring
October 16, 2008
Question

Connecting to SQL Server in CF8

  • October 16, 2008
  • 4 replies
  • 895 views
This is probably more of a SQL Server question than a ColdFusion question, but I'll ask anyway.

I'm trying to connect a SQL Server 2000 database (name: RSA) on server RSA to CF8 on server Earth. I'm pretty sure I have everything correct on the CF side. Random data source name, 'rsa' as the database, the server IP for the server (I also tried the DSN name), port 1433, and then the username and password. The advanced settings looked good so I left it alone.

This is my error message:
Connection verification failed for data source: admi-sql
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 207.148.212.79:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: my_server_ip_address:1433. Reason: Connection refused: connect

I am using the MS SQL Server driver.

Perhaps I'm using the wrong port? How would I find the correct port? I know the database is running and I've been able to connect to it on the RSA server with the username and password I'm using on Earth.

Any thoughts?

Thanks in advance!
This topic has been closed for replies.

4 replies

N
Newsgroup_User
Inspiring
October 19, 2008
kodemonki wrote:

> This is my error message:
> Connection verification failed for data source: admi-sql
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
> socket to host and port: 207.148.212.79:1433. Reason: Connection refused:
> connect

does your sql server box allow sql user connections? the authentication should
be setup to allow for both windows & sql authentication. and of course the cf
dsn user should be a sql user.

N
Newsgroup_User
Inspiring
October 16, 2008
kodemonki wrote:
> I can definitely ping to that port.
>
> Some additional information: these are my company's servers so I have almost complete control over them.

Can you connect to the database with some other remote tool such as
enterprise manager? Are the settings used there the same as what was
provided in the CF admin?
K
kodemonkiAuthor
Inspiring
October 16, 2008
I can definitely ping to that port.

Some additional information: these are my company's servers so I have almost complete control over them.
N
Newsgroup_User
Inspiring
October 16, 2008
kodemonki wrote:
>
> Perhaps I'm using the wrong port? How would I find the correct port? I know
> the database is running and I've been able to connect to it on the RSA server
> with the username and password I'm using on Earth.
>
> Any thoughts?
>


That would sure be the first thing to check out.

Make sure you can ping that ip address and that port on that address.
If that server is not responding to remote requests on that port then
nothing you do on the CF side is going to matter.

If you can ping those then we have to investigate further. If you can
not, you need to contact the people who maintain that server and find
out what (if anything) you should use to connect to it. They may have
configured it to use another port to make it less vulnerable. They may
have it locked down to not talk to anybody remotely, but then that would
be a very lonely database server.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices