Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
hvdtol
Yak Posting Veteran
50 Posts |
Posted - 2007-11-20 : 03:06:34
|
Hello,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 - SecurablesWhat is wrong?Additional information - select serverproperty('Collation')Latin1_General_CI_ASselect name, collation_name, compatibility_level from sys.databasesname collation_name compatibility_levelmaster Latin1_General_CI_AS 90tempdb Latin1_General_CI_AS 90model Latin1_General_CI_AS 90msdb Latin1_General_CI_AS 90ReportServer Latin1_General_CI_AS_KS_WS 90ReportServerTempDB Latin1_General_CI_AS_KS_WS 90 ADB_ReportServer Latin1_General_CI_AS_KS_WS 90ADB_ReportServerTempDB Latin1_General_CI_AS_KS_WS 90ADB_Orga SQL_Latin1_General_CP1_CI_AS 90I 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,hvdtol |
|
|
|
|