SQL 2008 JDBC Repository Setup (JasperServer running on CentOS 6.2)

[ntalbot77]

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.

 

 

[Ching Ice-creaming]

If you are using Tomcat 5.5, you should copy jdbc drivers to $TOMCAT_HOME/common/lib.

If you are using Tomcat 6.0 or after, you should copy jdbc drivers to $TOMCAT_HOME/lib.

[mikewoinoski]

Check the logs in /opt/jasperreports-server-4.5/apache-tomcat/logs and /opt/jasperreports-server-4.5/apache-tomcat/webapps/jasperserver-pro/WEB-INF/logs. The error messages may give details about the cause.