none
Management Studio - Database Collation: Error 468

    Question

  • Hi,

    I have a mirrored SQL 2008R2 configuration with several application and SSRS databases. This has been running fine for > 1 year.

    I now get this Collation error in SSMS when attempting to look at the properties of any database on the server and attempting to access the Tasks/Mirror... dialogue. The only significant change since this was last working ok is the installation of the SSRS databases.

    Our training system has the same databases (not mirrored, appdbs restored from Production) and I can access the db properties OK. The master and msdb have different collation types (see below) between Production and Training. Is this the root of the problem and is this something I can correct? Can someone advise how I can fix this problem? Thanks.

    Production
    appdb1 Collation=Latin1_General_CI_AS,
    appdb2 Collation=Latin1_General_CI_AS,
    appdb3 Collation=Latin1_General_CI_AS,
    appdb4 Collation=Latin1_General_CI_AS,
    master Collation=SQL_Latin1_General_CP1_CI_AS,
    model Collation=Latin1_General_CI_AS,
    msdb Collation=SQL_Latin1_General_CP1_CI_AS,
    ReportServer Collation=Latin1_General_CI_AS_KS_WS,
    ReportServerTempDB Collation=Latin1_General_CI_AS_KS_WS,
    tempdb Collation=Latin1_General_CI_AS,

    Training
    AdventureWorksDW2008R2 Collation=SQL_Latin1_General_CP1_CI_AS,
    appdb1 Collation=Latin1_General_CI_AS,
    appdb2 Collation=Latin1_General_CI_AS,
    appdb3 Collation=Latin1_General_CI_AS,
    appdb4 Collation=Latin1_General_CI_AS,
    master Collation=Latin1_General_CI_AS,
    model Collation=Latin1_General_CI_AS,
    msdb Collation=Latin1_General_CI_AS,
    ReportServer Collation=Latin1_General_CI_AS_KS_WS,
    ReportServerTempDB Collation=Latin1_General_CI_AS_KS_WS,
    tempdb Collation=Latin1_General_CI_AS,

    Friday, October 11, 2013 2:15 PM

Answers

All replies