DBInputTable: compatibility with Microsoft SQL EXPRESS 2008 R2

jzhu

• November 08, 2016 00:00

• Answered

Follow

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.

• 

  jzhu

  • November 09, 2016 10:29

  0

  Comment actions Permalink

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

  mrhong13371

  • December 02, 2016 15:14

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.