Configure jdbc datasource for SQL server

[apoorv7512]

I was trying to configure the jdbc configuration for SQL server. am getting an error. shall be thankful for help in this regard.

 

also if jdbc connection is not the right way then what is the right way for connecting with SQL server database?

[def_admin]

The full error message will be in the server logs at tomcat/webapps/jasperserver/WEB-INF/logs/jasperserver.log

 

Have a look at http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/DataSources

 

Sherman

Jaspersoft

[apoorv7512]

I followed the steps that you have mentioned in the mail.

I was getting the connection as failed. I am sending the error log file below.

 

Please consider the following:

1.) We have been able to configure the connection in I-report also. It works fine.

2.) I have configured a system dsn and user dsn connection as 'sqlserverconnection'

3.) The database that needs to be accessed is 1Redx

4.) The server address is 74.127.8.180

5.) I have windows authentication. The username is VDS-apoorv\Administrator

 

I sought to change the entries as follows:

com.microsoft.sqlserver.jdbc.sqlserverconnection

 

jdbc:sqlserver://74.127.8.180:1433:databasename=1Redx;

 

I am still getting an error.

 

where am I making a mistake?

 

 

 

[ramnik]

This error is caused by missing jdbc driver.

 

Please Copy the right jdbc driver for SQL server - sqljdbc-1.6 in the directory :- {TOMCAT_HOME} /lib

 

 

[apoorv7512]

are you referring to jdbc driver 1.2? that is what I found on the mcrosoft web site.

 

right now the connection is still not working.

[mdahlman]

apoorv7512,

Your posting says that you are using the class "com.microsoft.sqlserver.jdbc.sqlserverconnection".

Your log says that it's looking for the class "com.mysql.jdbc.sqlserverconnection". So it looks like you have not configured things as you thought you did.

The correct class is "com.microsoft.sqlserver.jdbc.SQLServerDriver", and it's case sensitive as all Java classes are.

I wrote a tutorial to help with connecting to SQL Server. Take a look at the attached doc to see if it helps.

Regards,
Matt