Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error 468: Cannot resolve collation conflict

Author  Topic 

Yak Posting Veteran

50 Posts

Posted - 2007-11-20 : 03:06:34

Recently we installed a new version sql 2005 sp2 on a Windows 2003 server.
At installaion time we choose the Windows Locale for the collation (this was the default- the server was installed with Dutch
The Netherlands).
The first application database we have created is with SQL_Latin1_General_CP1_CI_AS (the supplier of the application supplied the database creation scripts with this collation, we did not change).

When i clik on - security - logins, select a user and click on Securables, i receive error 468:
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS"in the UNION operation.

The error only occurs when we click successively on General - Server Roles - User Mapping - Securables
What is wrong?

Additional information
- select serverproperty('Collation')

select name, collation_name, compatibility_level from sys.databases
name collation_name compatibility_level
master Latin1_General_CI_AS 90
tempdb Latin1_General_CI_AS 90
model Latin1_General_CI_AS 90
msdb Latin1_General_CI_AS 90
ReportServer Latin1_General_CI_AS_KS_WS 90
ReportServerTempDB Latin1_General_CI_AS_KS_WS 90
ADB_ReportServer Latin1_General_CI_AS_KS_WS 90
ADB_ReportServerTempDB Latin1_General_CI_AS_KS_WS 90
ADB_Orga SQL_Latin1_General_CP1_CI_AS 90

I have read many thing on the web concerning collation error 468, and that it has to do with the tempdb, but i still do not know......
- Do i have a problem, because the error only occurs in SSMS (as far as we know now)?
- Do all my present and future database should have the collation Latin1_General_CI_AS?
- What if some application required different collation?

All information is welcome.

Best regards,



- Advertisement -