Lucee 5.3.3.62 Error (database)
Message The TCP/IP connection to the host 192.168.0.247, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
Stacktrace The Error Occurred in
C:\Sites\coronavirustest\FindAPractice\include\siteConfiguration.cfm: line 12
10: Select * from PhysicianFinderSiteConfiguration
11: where sitename like '#application.currentsite#'
12: </cfquery>
13: <cfloop query="getConfiguration">
14: <cfif #configurationName# eq "indexedBy">

called from C:\Sites\coronavirustest\FindAPractice\application.cfm: line 60
Java Stacktrace lucee.runtime.exp.DatabaseException: The TCP/IP connection to the host 192.168.0.247, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
  at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
  at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
  at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
  at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
  at lucee.runtime.db.DataSourceSupport._getConnection(DataSourceSupport.java:111)
  at lucee.runtime.db.DataSourceSupport.getConnection(DataSourceSupport.java:93)
  at lucee.runtime.db.DatasourceConnectionPool.loadDatasourceConnection(DatasourceConnectionPool.java:134)
  at lucee.runtime.db.DatasourceConnectionPool.getDatasourceConnection(DatasourceConnectionPool.java:101)
  at lucee.runtime.db.DatasourceManagerImpl.getConnection(DatasourceManagerImpl.java:73)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1038)
  at lucee.runtime.tag.Query._doEndTag(Query.java:655)
  at lucee.runtime.tag.Query.doEndTag(Query.java:537)
  at findapractice.include.siteconfiguration_cfm$cf$1.call(/FindAPractice/include/siteConfiguration.cfm:12)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:942)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:816)
  at findapractice.application_cfm$cf$1.call(/FindAPractice/application.cfm:60)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:942)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:55)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2409)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2399)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2374)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1055)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Unknown Source)
 
Timestamp 6/3/23 6:18:02 PM EDT