Unable to see tables/views from SQL server when extracting the Schema

PROBLEM:

I'm unable to see any tables or database views when extracting a schema from MS SQL Server.

SOLUTION: 
1. Check if the connecting user (account configured in the RadiantOne data source) has the right privileges in the SQL Server database to access the MetaData schema.
2. Use third party tools like SQL Squirrel Client or DB visualizer to view the tables using the same service account:
http://squirrel-sql.sourceforge.net/
3. Try restarting the RadiantOne tools you are using to extract the schema (e.g. Control Panel, Context Builder) and the RadiantOne FID service.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section