Jasperserver <-> MS SQL

[mygil]

Hello!

I have a problem with the data connection between the Jasper Server and MS SQL Server 2008!
I can not create a working datasource!

Some of my Installations Steps:
1. I installed: 'iReport-4.0.2-windows-installer "(not the pro version!)
2. I installed "sqljdbc_3.0.1301.101_deu" -> C: Program Files (x86) Microsoft SQL Server JDBC Driver 3.0
3. I copied: "sqljdbc.jar" & "sqljdbc4.jar" From: "C: Program Files (x86) Microsoft SQL Server JDBC Driver 3.0 sqljdbc_3.0 eng" -> "C:Program Filesjasperreports-server-cp-4.1.0apache-tomcatwebappsjasperserverWEB-INFlib"
4. Restarded the server

Here my data source settings:
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
URL: jdbc: sqlserver: / / [SERVER NAME]: 1433; DatabaseName = [DATABASE NAME]
Username: [USERNAME]
Password: [USER PASSWORD]

Creating a Report with iReport works fine!
But when i create a datasource (http://trdev01:8080/jasperserver/login.html / add data sources) i always get an error when i try the connection! 

/tools/fckeditor/editor/images/smiley/msn/confused_smile.gifCan anybody help me please?

 

Post Edited by mygil at 07/18/2011 11:24

[nsgarvind]

hi ...

go through this link...

http://www.rhyous.com/2009/10/27/adding-a-sql-2008-server-as-a-datasource-to-jasperserver/

[samerzohdi]

 

nsgarvind > Thank you very very very much for your support and help

now I got connection passd./tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

really thank you /tools/fckeditor/editor/images/smiley/msn/thumbs_up.gif

 

Samer

 

[nsgarvind]

Hi Samer,

                       Which Version of  Jasper Server  using in your Application?  Datasource - SQLServer 2005 or 2008 R2 ?

 Arvind NSG

Post Edited by nsgarvind at 07/19/2011 08:23

[samerzohdi]

 

Hi,

I am using JS 4.1 with SQL Server 2005

Thanks,

Samer