I cannot connect to the datasource

6 replies
1663 views
Translate

Dear,

I am using coldfusion8.

And when trying to connect to a sql server data source which need to provide a servername. I had provided one domain name.

But cfusion said that the IP cannot be established the connection.

I guess cfusion has parsed the domain name to IP and using IP to connect.

That will not be allowed by the sql server data source.

How should I configure to make cfusion accept a domain name without paring it?

Thanks.

coldfusion 8

This topic is closed to new replies. Start a new post to keep the conversation going.

H

haxtbh

Inspiring

What is the exact error you are receiving.

What is the version of SQL Server?

It wouldn't matter if its hostname or IP, it should connect unless something is blocking it. You are using a very old version of CF. If you are using a newer version of SQL Server then the support wont be there which could be the start of the issues.

Translate

T

thaic1219697Author

Inspiring

Dear Haxtbh,

Thanks again for supporting me.

The error I get is:

Connection verification failed for data source: wwf_intra3.oranxo

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open server "23.98.55.75" requested by the login. The login failed.

The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open server "23.98.55.75" requested by the login. The login failed.

I’ve tested and found that it can work only with the domain name hmnomd30wm.database.windows.net

The server now only allows some limited IP to connect.

Translate

BKBK

Community Expert

You perhaps have to configure the firewall on the database server to allow connections from the ColdFusion server. Oh, just so you know, when I ping hmnomd30wm.database.windows.net, it resolves to northcentralus1-a.control.database.windows.net

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.