baseballstorm50 Posted December 19, 2012 Share Posted December 19, 2012 Hi, I am new to JasperReports software, and I have downloaded the new JasperServer 5.0.0 Community Edition for my 64-bit Windows machine. I am attempting to learn how to use the iReports Designer that came included with the JasperServer package. I have been trying to follow the instructions included on this page: http://community.jaspersoft.com/wiki/basic-report-creation However, I am having issues on the "Define Data Source" section. I am attempting to connect to the sample "food mart" database. Here is a screenshot of my action:When I click test I get prompted to type in the password again:So, I type "jasperdb" and then an error window pops up that says the authentification failed:I believe that this database should be working, because when I log into my local JasperServer through my browser, I can see Analysis Components > Analysis Data Sources > Foodmart Data Source (which has "type" JDSB Data Source), and all of the information is the same Name - Foodmart Data Source Driver - org.postgresql.Driver URL - jdbc:postgresql://127.0.0.1:5432/foodmart name - jasperdb password - jasperdb Does anyone have any insight into why I am having this issue? Do you have any advice/suggestions on how I can test iReport Designer using the sample "Foodmart" database? Thanks! Link to comment Share on other sites More sharing options...
Solution dbooth Posted December 20, 2012 Solution Share Posted December 20, 2012 Try the credentials (userid / password): jasperdb / password instead of: jasperdb / jasperdb.You can see this if you log into JasperReports Server, select View -> Search Results, under All types, select More choices, select Data sources. Right mouse click on Foodmart Data Source and select Test Connection. You'll get a Connection passed msg. If you change the password to: jasperdb and reselect the Test Connection button, you'll get a Connection failed msg. Change the password back to: password, and the Test Connection will pass again.In addition, if you select the Save password check box in iReport, then you'll not get the Password pop-up window. Link to comment Share on other sites More sharing options...
baseballstorm50 Posted January 8, 2013 Author Share Posted January 8, 2013 Thank you, that worked! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now