Hi, I don't have much experience with JasperServer, but we have been using it for quite sometime to generate report. We were using postgres database connector and had no issues. Now I am trying to connect to a MSSQL Database but for some unkown reason I am unable to make it work. I've been trying all I could think. This is the 2 datasource I tested. Both says Test Successfull net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sqlserver://zz60:1433/Heat and sun.jdbc.odbc.JdbcOdbcDriver jdbc:odbc:heat1 Also I run the report just fine in iReport, then I upload to the jasperserver, the database are test successfull and I try to run the report I get problem with the MsTDC Caused by: java.sql.SQLException: The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. I went into the component configuration and made sure the Allow incoming and Allow outgoing is check in, I run my jasperserver as a service, I changed the service credential for a full domain admin. I run the same query in the ireport I get it within seconds and the report it good. I even tried running the jasperserver in the console of the running user. I am out of ideas, if anyone has anything they can share to help out it would be very handy! :) Thanks!!!!!! NorthFace.
