barb_1 Posted December 20, 2017 Share Posted December 20, 2017 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. Link to comment Share on other sites More sharing options...
Solution barb_1 Posted December 20, 2017 Author Solution Share Posted December 20, 2017 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. 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