SQL Error: 18456, SQLState: 28000
[2009-06-30 09:31:55,185]ERROR154560[TP-Processor62] (JDBCExceptionReporter.java:58) - Login failed for user
Ensure the proper permissions and also check that the activity log or management log to see if the problem is shown. The problem in this case was that the authentication was set to windows only and this needed to be changed. Changes can be made in the management console via options on the user radio check boxes for SQL Server Authentication which need to be active.