There are several test cases that fail in SQL Server:
org.hibernate.test.cid.CompositeIdTest > testDistinctCountOfEntityWithCompositeId FAILED javax.persistence.PersistenceException at CompositeIdTest.java:106 Caused by: org.hibernate.exception.SQLGrammarException at CompositeIdTest.java:106 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CompositeIdTest.java:106 org.hibernate.test.filter.DynamicFilterTest > testSqlSyntaxOfFiltersWithUnions FAILED javax.persistence.PersistenceException at DynamicFilterTest.java:88 Caused by: org.hibernate.exception.SQLGrammarException at DynamicFilterTest.java:88 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at DynamicFilterTest.java:88 org.hibernate.test.hql.ASTParserLoadingTest > testJPAPositionalParameterList FAILED javax.persistence.PersistenceException at ASTParserLoadingTest.java:1440 Caused by: org.hibernate.exception.SQLGrammarException at ASTParserLoadingTest.java:1440 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ASTParserLoadingTest.java:1440 org.hibernate.test.hql.ASTParserLoadingTest > testOrderedWithCustomColumnReadAndWrite FAILED javax.persistence.PersistenceException at ASTParserLoadingTest.java:2237 Caused by: org.hibernate.exception.SQLGrammarException at ASTParserLoadingTest.java:2237 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ASTParserLoadingTest.java:2237 org.hibernate.test.hql.BulkManipulationTest > testDeleteWithMetadataWhereFragments FAILED org.hibernate.exception.SQLGrammarException at BulkManipulationTest.java:1333 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at BulkManipulationTest.java:1333 org.hibernate.test.hql.CriteriaHQLAlignmentTest > testCountReturnValues FAILED javax.persistence.PersistenceException at CriteriaHQLAlignmentTest.java:267 Caused by: org.hibernate.exception.SQLGrammarException at CriteriaHQLAlignmentTest.java:267 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CriteriaHQLAlignmentTest.java:267 org.hibernate.test.hql.WithClauseTest > testWithClauseAsSubqueryWithKeyAndOtherJoinReference FAILED javax.persistence.PersistenceException at WithClauseTest.java:255 Caused by: org.hibernate.exception.SQLGrammarException at WithClauseTest.java:255 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at WithClauseTest.java:255 org.hibernate.test.legacy.FooBarTest > testCollectionsInSelect FAILED javax.persistence.PersistenceException at FooBarTest.java:2297 Caused by: org.hibernate.exception.SQLGrammarException at FooBarTest.java:2297 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at FooBarTest.java:2297 org.hibernate.test.lob.LobStringTest > testSelectClobPropertyInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:151 Caused by: org.hibernate.exception.DataException at LobStringTest.java:151 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:151 org.hibernate.test.lob.LobStringTest > testSelectStringLobAnnotatedInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:121 Caused by: org.hibernate.exception.DataException at LobStringTest.java:121 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:121 org.hibernate.test.lob.LobStringTest > testUsingLobPropertyInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:136 Caused by: org.hibernate.exception.DataException at LobStringTest.java:136 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:136 org.hibernate.test.lob.LobStringTest > testUsingStringLobAnnotatedPropertyInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:97 Caused by: org.hibernate.exception.DataException at LobStringTest.java:97 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:97 org.hibernate.test.querycache.QueryCacheTest > testCaseInsensitiveComparison FAILED java.lang.AssertionError at QueryCacheTest.java:276 org.hibernate.test.reattachment.CollectionReattachmentTest > testUpdateOwnerAfterClear FAILED javax.persistence.PersistenceException at CollectionReattachmentTest.java:47 Caused by: org.hibernate.exception.SQLGrammarException at CollectionReattachmentTest.java:47 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CollectionReattachmentTest.java:47 org.hibernate.test.reattachment.CollectionReattachmentTest > testUpdateOwnerAfterEvict FAILED javax.persistence.PersistenceException at CollectionReattachmentTest.java:74 Caused by: org.hibernate.exception.SQLGrammarException at CollectionReattachmentTest.java:74 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CollectionReattachmentTest.java:74 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithClearBottomOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:145 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:145 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithClearTopOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:109 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:109 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithEvictBottomOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:222 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:222 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithEvictTopOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:187 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:187 org.hibernate.test.reattachment.ProxyReattachmentTest > testRemoveAndReattachProxyEntity FAILED javax.persistence.PersistenceException at ProxyReattachmentTest.java:250 Caused by: org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:250 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:250 org.hibernate.test.reattachment.ProxyReattachmentTest > testUpdateAfterClear FAILED javax.persistence.PersistenceException at ProxyReattachmentTest.java:77 Caused by: org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:77 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:77 org.hibernate.test.reattachment.ProxyReattachmentTest > testUpdateAfterEvict FAILED javax.persistence.PersistenceException at ProxyReattachmentTest.java:51 Caused by: org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:51 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:51 org.hibernate.test.schemaupdate.foreignkeys.crossschema.CrossSchemaForeignKeyGenerationTest > testSchemaMigrationForeignKeysAreGeneratedAfterAllTheTablesAreCreated FAILED org.hibernate.exception.SQLGrammarException at CrossSchemaForeignKeyGenerationTest.java:160 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CrossSchemaForeignKeyGenerationTest.java:160 org.hibernate.test.sql.autodiscovery.AutoDiscoveryTest > testDialectGetColumnAliasExtractor FAILED org.hibernate.exception.SQLGrammarException at AutoDiscoveryTest.java:127 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at AutoDiscoveryTest.java:127 org.hibernate.test.sql.autodiscovery.AutoDiscoveryTest > testSqlQueryAutoDiscovery FAILED javax.persistence.PersistenceException at AutoDiscoveryTest.java:111 Caused by: org.hibernate.exception.SQLGrammarException at AutoDiscoveryTest.java:111 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at AutoDiscoveryTest.java:111 org.hibernate.test.sql.hand.custom.sqlserver.SQLServerCustomSQLTest > testImageProperty FAILED javax.persistence.PersistenceException Caused by: org.hibernate.exception.SQLGrammarException Caused by: com.microsoft.sqlserver.jdbc.SQLServerException org.hibernate.test.sql.hand.custom.sqlserver.SQLServerCustomSQLTest > testTextProperty FAILED javax.persistence.PersistenceException Caused by: org.hibernate.exception.SQLGrammarException Caused by: com.microsoft.sqlserver.jdbc.SQLServerException org.hibernate.test.sql.hand.query.NativeSQLQueriesTest > testAutoDetectAliasing FAILED javax.persistence.PersistenceException at NativeSQLQueriesTest.java:577 Caused by: org.hibernate.exception.SQLGrammarException at NativeSQLQueriesTest.java:577 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at NativeSQLQueriesTest.java:577 org.hibernate.test.sql.hand.query.NativeSQLQueriesTest > testImageTypeInSQLQuery FAILED javax.persistence.PersistenceException at NativeSQLQueriesTest.java:870 Caused by: org.hibernate.exception.SQLGrammarException at NativeSQLQueriesTest.java:870 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at NativeSQLQueriesTest.java:870 org.hibernate.test.sql.hand.query.NativeSQLQueriesTest > testTextTypeInSQLQuery FAILED javax.persistence.PersistenceException at NativeSQLQueriesTest.java:849 Caused by: org.hibernate.exception.SQLGrammarException at NativeSQLQueriesTest.java:849 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at NativeSQLQueriesTest.java:849 org.hibernate.test.temporal.TimePropertyTest > testTimeAsDate FAILED javax.persistence.PersistenceException at TimePropertyTest.java:59 Caused by: org.hibernate.exception.SQLGrammarException at TimePropertyTest.java:59 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at TimePropertyTest.java:59