Below are some common errors and examples.
- Double check all the configuration values and that the JDBC driver is installed in the correct location
- Make sure you restarted Confluence after making configuration changes to server.xml or equivalent application server configuration (when a different application server is being used)
- Make sure your database is configured from remote access from the Confluence server with the user and password provided. If you have problems, connect using an independent SQL client from the server to verify access. Consult your database documentation for how to configure remote access and database permissions
The resolution can be different for application server based Data Sources (application server) or Data Source Profiles which extend a Data Source. In most cases, you will see Error rendering macro 'sql' or Error rendering macro 'sql-query'