Amazon festival offer

Wednesday, 25 April 2012

Connect Ireport to MS SQL Server database

To create a MS SQL Server database in Ireport, you need a sqljdbc driver.

Steps to create MS SQL Server database in Ireport:-

1:- Download sqljdbc (1033\sqljdbc_3.0.1301_enu.exe) driver from

After downloading driver, extract the sqljdbc4.jar file and paste into this location

                            C:\Program Files \Jaspersoft\iReport-4.0.2\ireport\modules\ext
2:-Start Ireport and go to Tool and then select Optios

Click on Class Path tab, click on Add jar tab and browse the sqljdbc4.jar file


After adding the jar file restart the Ireport.
Now you can create MS SQL Server database in Ireport.


Unknown said...

help me please, i have conected ireport with sqlserver, but non php, how i does make it's. please helpe me.

gibsonherry said...

I appreciate this blog to share knowledge about this important topic. Here I found different segments and now I am going to use these new tips with new enthusiasm.
Windows Server Datacenter

Unknown said...

nice blog
SQL Server DBA Online course hyderabad