Has anyone had any luck with connecting to an mssql 2k8 db repository? Here are the steps I am doing 1. DL mssql drivers from here: http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz 2. unpack to temp 3. Copy the sqljdbc4.jar and sqljdbc.jar to /opt/jasperreports-server-4.5/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib (I also make both of these files executable once they are copied) 4. Restart Server (/opt/jasperreports-server-4.5/ctlscript.sh restart) 5. Login to Gui and add repo like this: Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver Database: jdbc:sqlserver://10.4.20.47:1433;databaseName=Jasper; 6. Add user and pass My tests are failing every time and I cannot figure out why, unless I am copying the drivers to the incorrect directory. Any advice would be greatly appreciated.
