MS SQL Server MetaDataException: Cannot get database meta info

MetaDataException when creating new domain

A customer created a new Domain, clicked 'Edit with Domain Designer', and at the moment when the Designer should prompt the user to select a database schema they were given an error:  "MetaDataException: Cannot get database meta info"

Log analysis showed this root error:

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the INTERSECT operation.

Resolution:

This customer was using  Microsoft Sql Server 2008 r2 , JAVA version 1.6.0_43.  Their DBA indicated no known collation problems across their tables.

They found that replacing the microsoft jdbc driver, sqljdbc4.jar, with a newer version resolved the problem.  Apparently there is an obscure defect in the older version of that driver.

Ref. Case #00049457