Before you begin
You will need:
Developer access to the ColdFusion or Lucee Administrator.
Access to the database server or the ability to verify database credentials.
The specific error message or code generated by the application.
Check the Data Source Configuration
Verify that the connection details in the ColdFusion or Lucee Administrator are correct.
Log in to the ColdFusion Administrator or Lucee Administrator.
Navigate to Data Sources > Your Data Source Name.
Verify the following fields:
Host: Ensure the hostname or IP address is correct.
Port: Confirm the database is listening on the expected port (e.g., 3306 for MySQL, 1433 for MS SQL).
Username: Ensure the username is correct.
Password: Re-enter the password to ensure no typos exist.
Driver: Ensure the correct JDBC driver is selected for your database type.
Click Test Connection (if available in your version) to verify the link.
Verify Network Connectivity
If the configuration is correct but the connection fails, the issue may be at the network layer.
Log into the server hosting the ColdFusion or Lucee application via SSH or Remote Desktop.
Use a tool like
telnetto check if the database server is reachable.Example:
telnet 192.0.2.10 3306
If the connection fails, the issue may be a firewall blocking the port or an incorrect IP address.
Check Database Permissions
The database may be reachable, but the specific user may not have permission to connect from the application server's IP.
Log into your database management tool (e.g., phpMyAdmin, MySQL Workbench, or SQL Server Management Studio).
Verify that the user account exists.
Ensure the user has permissions to access the specific database.
Confirm that the user is allowed to connect from the IP address of the ColdFusion or Lucee server.
Check Database Service Status
The database service may have stopped or crashed.
Log into the database server.
Check the status of the database service (e.g., MySQL, MariaDB, or MSSQL).
Restart the service if it is not running.
Confirm Database Limits
The database may be rejecting connections because it has reached its maximum allowed limit.
Check the maximum number of concurrent connections allowed by the database.
Check the current number of active connections.
If the limit is reached, you may need to increase the limit or optimize your application's connection pooling.
How to Troubleshoot a CFML Data Source Connection Error
If you receive a "Connection Refused" error, the issue is typically a firewall or a stopped service. If you receive an "Access Denied" error, the issue is typically incorrect credentials or restricted user permissions.
Contact Hostek Support
If you have verified the credentials, confirmed network connectivity, and ensured the database service is running, contact Hostek Support. Provide the following information to assist with the investigation:
The specific error message or code.
The name of the Data Source in the ColdFusion or Lucee Administrator.
The IP address of the database server.
The port number being used.
