cfml

I am trying to do some basic CF 2018 installation and I am getting  Timed out trying to establish connection. I have everything setup on IIS and can get to my site. is this error related to SQL or is on the CF side? Has anyone had a similar issue when setting CF with an IIS site?

Yes, please post the error. Also, you should make sure that your windows server doesn't have firewall set to block  (I'm assuming) port 80. Until you find out, you might want to just disable the firewall (which is what I do). Also, ensure that you have configured SQL server to be on port 1433 (by default its not). That should get you started anyway. Again, the post the error so we can see what you are getting. What server version are you running?

I have Windows Firewall disabled on the server. below is the error.

In addition to <@U07MGLDAQ> comments above, make sure SQL Server has the TCP/IP protocol enabled (this is set using the SQL Server Configuration Manager) for "SQL Native Client ##.0 Configuration (32bit)/Client Protocols", "SQL Native Client ##.0 Configuration/Client Protocols", and "SQL Server Network Configuration/Protocols for MSSQLSERVER".  Note the ## might vary based on what version of SQL Server you are running.  Also, the MSSQLSERVER is the default name for the SQL Server instance - if you have changed the name or configured SQL Server with multiple instances, find the appropriate one under "SQL Server Network Protocols".

Furthermore, I have two other servers in production accessing the same SQL database and the same application and they work fine. This is a new server I am setting up and I can get to the login screen of the site from the new server BUT I get the Time out error when I login.

Are the data sources set up in CFAdmin or in Application.cfc settings?  And if the former, did you create the data sources in CFAdmin to match the settings in your other servers?

that is correct. data sources and all other settings have already been configured on CFAdmin to match the other servers.

Let me correct myself oh this. I was able to figure it out. it was in fact an issue with the data source in CFAdmin. Coldfusion allowed me to add a database, however I missed some settings on that database and because of that I was getting the time out error. Should be good now! thank you everyone for your help!