The server name or address could not be resolved

[ssailer]

I am using the following:

— ColdFusion 2021
— SQL Server Express 2019
— SQL Server Management Studio 18.12.1

— Dreamweaver

I'm trying to set up a data source in the database tab, but when I click on RDS Login, I get the following error message:

1. The URL specified for this site's testing server may be incorrect: http://localhost:8500/estimates/

2. The testing server may be incorrectly configured (for example, ColdFusion may not be running).

I have created a data source in CF Aadmin, and I'm able to connect to the database, if I hard code the query into Dreamweaver, the query and code runs just fine.  I just can't do it through the database panel.  To clarify, the testing server is correct because I can view the files when I type in the URL.

The ColdFusion server is running - I checked it in Windows >> Services. 

I just can't connect to the database in Dreamweaver's Databases panel.

Thank you.  

[BKBK]

Is  http://localhost:8500/estimates/ perhaps the URL of your test site? It seems you have mistakenly entered this URL somewhere (in the RDS settings) as the URL of the Administrator. So check your Dreamweaver RDS settings.

[ssailer]

Just to be clear, it's the server settings within the site setup that you're asking me to check?  If so, I'm referencing localhost as the remote and testing server. 

server folder:  C:\ColdFusion2021\cfusion\wwwroot\estimates\

web url:  http://localhost:8500/estimates/

Thank you so much for offering to help.  I'm still stuck.  😕 

[BKBK]

Save the following code as the file C:\ColdFusion2021\cfusion\wwwroot\estimates\index.cfm

In index.cfm<br>
Time is: <cfoutput>#now()#<cfoutput>

What happens when you now launch this URL in the browser: http://localhost:8500/estimates/ 

[ssailer]

Sorry, I've been working on another project and just got back to this.  As soon as I add any ColdFusion code to the page, I get the same error.  Interestingly, when I'm setting up the site and try to enter data for the RDS login, I get the following error:

The server name or address could not be resolved. 

1. The URL specified for this site's testing server may be incorrect: http://localhost:8500/estimates/
2. The testing server may be incorrectly configured (for example, ColdFusion may not be running).

CF ADMIN is running on:  http://127.0.0.1:8500/CFIDE/administrator/index.cfm and ColdFusion is definitely running.  I can get into CF Admin and my data sources are working, they've been validated. I've even tried the following, but it doesn't work either. http://127.0.0.1:8500/estimates/

I am completely stumped.  😕 

[ssailer]

I created a brand new site, from scratch, and I can add your code above to the page, and it does not produce an error.  However, I still can't specify the RDS Login - I get the same error as before, so I can't connect to a database.  Yes, the data source is set up and it's valid.  I am so stumped!  😕 

[ssailer · Accepted solution]

I just got this resolved.  Come to find out, RDS was not enabled in CF Administrator.  The pages are working now!!!  😄 

[BKBK]

Thanks for sharing that.