Unable to Connect to Database Due to Database Authentication
- The JIRA context fails to initialize.
- The browser displays
HTTP Status 404 - The requested resource is not available.
Application logs contain the following error:
2007-09-25 10:51:39,623 Thread-1 ERROR [atlassian.jira.service.DefaultServiceManager] Could not configure services: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot create PoolableConnectionFactory (Login failed for user 'jirauser'.)) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
The credentials used to login to the DBMS are invalid, don't exist or are missing sufficient permissions to connect.
- Verify the username and password used in the JDBC driver definition.
- Ensure that the DBMS user exists and the permissions granted are sufficient.
If you're trying to connect to a MS SQL database that is running on a port that is not the default (non-standard), please take a look through this MSDN blog on tips for making application connectivity work.