Tested SQL Server Collations:
Current version cannot be determined. The metadata table (m_global_metadata) is missing or inaccessible.
Since version 3.9, midPoint checks for presence of table m_global_metadata and will not start if table is not found. However, If you have DB wrongly set - missing the ALLOW_SNAPSHOT_ISOLATION option, you will not get usual "SQLServerException: Snapshot isolation transaction failed" but rather confusing error that m_global_metadata table is missing. So you just run "ALTER DATABASE "midpoint" SET ALLOW_SNAPSHOT_ISOLATION ON;" to fix it.
When installing the driver, please use sqljdbc4.jar when your application must run on JRE 6.0 or 7.0, even if your application does not use JDBC 4.0 API features. (Quote from (MS) System requirements for the JDBC Driver.)