SQL Server Collation

[psycdoc]

Can anyone tell me what the collation setting should be on SQL Server 2012.

[mrogers]

Docs say default.

[psycdoc]

I changed my default collation when I installed my SQL server. I had to do this for another application that has a database on the server. So now I need to know what Alfresco prefers at its collation. 

[psycdoc]

I am receiving this error:

13:34:52,206 ERROR [org.alfresco.util.DatabaseMetaDataHelper] [localhost-startStop-1] Unable to determine current schema.
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the INTERSECT operation.