sb.append("select table_name from INFORMATION_SCHEMA.Tables where lower(table_name) = ?");

which give following exception:
org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute sql [select table_name from INFORMATION_SCHEMA.Tables where lower(table_name) = ?]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'INFORMATION_SCHEMA.Tables'

Instead, use upper-case 'TABLES' instead of 'Tables':
sb.append("select table_name from INFORMATION_SCHEMA.TABLES where lower(table_name) = ?");

Running this from interactive sql query ui worked; have not tested with SqlServerDialect itself.