SQL server collation mismatch

Posted on 2009-04-17
Last Modified: 2012-05-06
I restore a sql database and got this error
the master database has a collation of Latin1_General_CI_AS

It needs to be

I am reinstalled the instance and have selected Latin1_General but what else do I have to do to get the CPI
Question by:jimcrint
    LVL 31

    Expert Comment

    collation conflict is with Master database only or will all tables under master database also?
    LVL 1

    Author Comment

    i dont know enough  It says the master database.  Says that I have to reinstall the sql server with the same instance with the collation including the CP1  then restore it again

    I am in the prcess of reinstalling and dont know what I have to tick to get the CP1 whatever it is
    LVL 31

    Expert Comment

    have a look at following steps and perform the steps rather than reinstallation.
    LVL 25

    Accepted Solution

    The CP1 stands for CodePage1252 which is the default  character set and is not relevant for Windows Collations.

    To set the collation to SQL_Latin1_General_CP1_CI_AS, choose SQL Collations (second option buttion) and select -
    "Dictionary order, case insensitive for use with code page 1252"

    LVL 1

    Author Comment

    i tried Ritesh link but  I was not able to complete the steps so I went back to another insatll and used reb27 commenst.  I have now restored the database and am back on track

    Thanks for being available, I dont know what I would do without all this great support

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now