Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect

The error occurred in C:/inetpub/GoTilley/TPT/index-4.cfm: line 2

1 : <cf_header>
2 : 	<cfquery name="locations" datasource="tilley">
3 : 		SELECT [ID]
4 : 	      ,[Location]

SQLSTATE	08001
SQL	SELECT [ID] ,[Location] ,[Name] ,[addressLine1] ,[addressLine2] ,[City] + ' ' + [State] + ', ' + [zip] as csz ,[email] ,[phone] ,[fax] from locations order by location
DATASOURCE	tilley

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	10.0.60.70
Referrer
Date/Time	15-Jul-26 12:12 PM

Stack Trace

at cfindex2d42ecfm973909296.runPage(C:/inetpub/GoTilley/TPT/index-4.cfm:2)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddc.<init>(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source)
	at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:722)