Jaspersoft 5 ZRS fails when using Windows Authentication for database user

  • 7015418
  • 23-Jul-2014
  • 23-Jul-2014

Environment

Novell ZENworks Configuration Management 11.3

Situation

After install, can't bring up ZENworks Reporting Server ZRS.

ERROR (in jasperserver.log):

2014-03-27 08:19:36,016 ERROR AdhocAjaxController,http-8443-7:810 - ad hoc controller exception: An error occurred while creating the connection. Try again.
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
2014-03-27 08:19:36,016 ERROR AdhocAjaxController,http-8443-7:810 - ad hoc controller exception: An error occurred while creating the connection. Try again.
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connectionCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 
'zcmwintest@pinellascounty-fl.gov'.

Resolution

Use a dbo that does not use integrated Windows authentication.

Cause

Windows Authentication mode is not supported if the database is an MS SQL server.  

Feedback service temporarily unavailable. For content questions or problems, please contact Support.