Cannot create PoolableConnectionFactory - Login failed for user 'xxxxx'

Issue:

Customer reported this issue when they created new JNDI connection. 

In jasperserver logs following error trace could be seen when testing the connection:

 java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user 'xxxxx'. ClientConnectionId:e2c4ed97-fea5-40a1-b14a-2d1292a66887) at 
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:668) at 
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:543) at 
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:752) at 

......
java.lang.Thread.run(Thread.java:748) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxxxx'. ClientConnectionId:e2c4ed97-fea5-40a1-b14a-2d1292a66887 at 
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at .....

They were using SQLServer DB client.

Cause:

In META-INF/config.xml, their custom JNDI data source didn't have "factory" attribute.

Resolution:

To resolve the issue- add the "factory" attribute. It looks something like this:

 factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"