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.
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.