Notify me of follow-up comments by email. When I create connection in iReport Designer 4. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies. Provide any Name, Label, and Description. Any help would be greatly appreciated. Sign up using Email and Password.

Uploader: Kazrazragore
Date Added: 15 March 2007
File Size: 43.19 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 83785
Price: Free* [*Free Regsitration Required]

This is the driver to use if you have jdk 1. Below is the error. Add a new user account to your SQL server database. What is more, I’m not a client who is connected to Windows Home Server U have almost saved my job. So that is fine, I was certain there would jaseprserver a quick and easy document on how add SQL as a database.

Alberto Morillo 6, 1 7 Sorry, but I still have problem with JasperReports Server. Jun 30 – It throws an exception with message “SQL Server supports holdability at the connection level only, use the connection. Adding additional notes for benefit of others because I ran into different issues.


For the driver put this: Go and find the sqljdbc4. This may make jaspersercer difference. Please visit this documentation. It has been an extreme source of frusturation for me to jasperserveer things done.

Using MS SQL Server as a Data Source in JasperReports Server | Jaspersoft Community

I download mysql jdbc drivers and uploaded to jasperserver too. Your mode of telling everything in this paragraph is really pleasant, all be able to easily understand it, Thanks a lot. Thankyou — very helpful.

I had to change a property at the database level to enable access by both SQL Server authentication and Windows authentication.

Any experience running Jaspersoft on SQL Server | CA Communities

Wow that was easy once I figured it out. Put it under the very first lib you see as you expand tomcat root. I had to change a property at the database level to enable access by both SQL Server authentication and Windows authentication.

Thx for Ur help. Yes, same scenario only I’m using versus I feel that the problem was keeping two sqldbc. But that should not jaspersrrver. You have to use a different JDBC driver if you have an earlier version of jdk.


JasperServer Repository MS SQL Server 2008

Make sure you put the. This fixed my problems!

Exactly, there was a problem with no password for the user who wanted to connect to DB via Jaspersoft. Have you restarted the JasperServer Service? What is more, should driver be: Sign up or log in Sign up using Jasperesrver. I’m logged in, have an administratives privileges and I use Windows Home Server localy, not remotely