How to resolve the Unable to connect to database error

Owned by Smita Nair
Last updated: Mar 02, 2020

Symptoms

One or more SQL macros return the following error:

Error rendering macro 'sql-query' : Unable to connect to database using jdbc:mysql://<HOSTNAME>:<PORT>/<DBNAME> with user <USER>

Cause

SQL macro is referencing a data source profile that has one or more incorrect connection configurations. 

Resolution

Double check the connection information associated with this data source profile such as: Hostname, Port, Database, Username, and, Password. 



Find answers from the community.

Ask a question to the community.

Log a request with our support team.


Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.