Domain Designer Not retrieving tables from DataSource

Posted on December 20, 2017 at 8:38am

Hi,

  I am currently using the evaluation version of JasperServer 6.4.2.    I have successfully created a new DataSource using JDBC pointing to SQL Server.  I am able to create a new domain and Launch the Domain Designer.  In that I select the new data source and I am able to select the appropriate schema from the list.  I proceed to close the Manage Data Source window and the icon in the Choose tables frame appears to be working but then showing no tables. 

The data source test connection shows that it cann connect. 

Can anyone please help.  Thanks.

JasperReports® Server
barb_1's picture
barb_1
38
Joined: Jun 28 2017 - 6:25pm
Last seen: 4 years 10 months ago

1 Answer:

Posted on December 20, 2017 at 9:37am

I updated the database user modifying the membership role to add "db_owner" which was not present.  This fixed the issue and I was able to import all the tables into the domain designer.

barb_1's picture
barb_1
38
Joined: Jun 28 2017 - 6:25pm
Last seen: 4 years 10 months ago
Feedback
randomness