topic SQL Server Collation in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307585#M260715 <HTML><HEAD></HEAD><BODY><SPAN>Can anyone tell me what the collation setting should be on SQL Server 2012.</SPAN></BODY></HTML> Tue, 14 Oct 2014 19:21:42 GMT psycdoc 2014-10-14T19:21:42Z SQL Server Collation https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307585#M260715 Can anyone tell me what the collation setting should be on SQL Server 2012. Tue, 14 Oct 2014 19:21:42 GMT https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307585#M260715 psycdoc 2014-10-14T19:21:42Z Re: SQL Server Collation https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307586#M260716 <HTML><HEAD></HEAD><BODY><SPAN>Docs say default.</SPAN></BODY></HTML> Thu, 16 Oct 2014 06:40:42 GMT https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307586#M260716 mrogers 2014-10-16T06:40:42Z Re: SQL Server Collation https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307587#M260717 <HTML><HEAD></HEAD><BODY><SPAN>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.&nbsp; </SPAN></BODY></HTML> Fri, 17 Oct 2014 19:57:11 GMT https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307587#M260717 psycdoc 2014-10-17T19:57:11Z Re: SQL Server Collation https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307588#M260718 <HTML><HEAD></HEAD><BODY><SPAN>I am receiving this error:</SPAN><BR /><BR /><SPAN>13:34:52,206 ERROR [org.alfresco.util.DatabaseMetaDataHelper] [localhost-startStop-1] Unable to determine current schema.</SPAN><BR /><SPAN>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.</SPAN></BODY></HTML> Fri, 17 Oct 2014 20:04:12 GMT https://connect.hyland.com/t5/alfresco-archive/sql-server-collation/m-p/307588#M260718 psycdoc 2014-10-17T20:04:12Z