Skip to main content
T
thaic1219697
Inspiring
October 14, 2017
Question

I cannot connect to the datasource

  • October 14, 2017
  • 1 reply
  • 1643 views

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.

This topic has been closed for replies.

1 reply

H
haxtbh
Inspiring
October 16, 2017

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.

T
thaic1219697Author
Inspiring
October 16, 2017

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.

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
October 16, 2017

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

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