JDBC-ODBC Datasource Error in Jaspersoft Server V5.5

[banderson_1]

Hello,

I am trying to setup a JDBC-ODBC Datasource in Jaspersoft Server V5.5. The same driver and url work correctly in iReport v5.5.

I am using sun.jdbc.odbc.JdbcOdbcDriver. The same driver works with iReport and JasperServer and iReport are installed on the same machine.

The url I am using is jdbc:odbc:eka

Error:[Microsoft]

[sql Server]Cannot open database "PAC Access Control Log" requested by the login. The login failed.

I find it interesting that when I choose "Test Connection", this error appears almost instantly.  It's odd that it can find the db name and still refuses to login.

Tried manually adding credentials to db in SQL management studio and error is replicated.

Any help in this matter would be greatly appreciated as this error is growing increasingly frustrating.

Thanks.