DBInputTable: compatibility with Microsoft SQL EXPRESS 2008 R2

CloverDX Platform
1

What could cause “SQL query editor” of DBInputTable to show database objects etc. but no user table?

I’ve two different database on Microsoft SQL EXPRESS 2008 R2, both restored from backup file on Microsoft SQL 2000.

In “SQL query editor” of DBInputTable, when expand the database, one shows the user tables, but the other shows dtproperties, CHECK_CONSTRAINTS, COLUMN_DOMAIN_USAGE, COLUMN_PRIVILEGES, COLUMNS etc., with no user table, as if the database is empty (same is shown if a database exists but empty).

Database connection is OK. “MS SQL Server 2008-2012” is selected for “JDBC specific” of the database connection. Tried “MS SQL Server 2000-2005”, same results.

Both SQL database can be accessed successfully with other SQL client, and data can be retrieved.
It seems the database is not corrupted.

Thanks.

2

This is now resolved. It is because one database needs sysadmin to access.

3

Hi,
doesn’t it depends on which authentication mode you are using for JDBC? If you are using Mixed Mode than DB user with sysadmin rights should be fine.