connection failed - JasperReports Server and MSSQL Server

[ahamdaoui]

I created a connection between  ireport and  the database wish data source located in Microsoft SQL Server 2008 and the connection 's successful

 the JDBC Driver I use is sqljdbc4.jar , I put the the JDBC driver here : c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib

I tried also with sqljdbc.jar

The JDBC URL :

JBDC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
JDBC URL: jdbc.microsoft.sqlserver://localhost:1433;DatabaseName=dbname;

However, when using Jasper server the connection fails 

Pls help.
 

[Ankur Gupta]

Hi, 

The problem here is that the path where you placed the jar file is wrong it should be - 

"c:program filesjasperserver-pro-3.5.1apache-tomcatlib"

Under this directory place the sqljdbc driver and it will work absolutely fine.

Regards,

Ankur

[ahamdaoui]

Thanks a lot Ankur.

regards,

Asma