The specified database has an incorrect collation

The specified database has an incorrect collation. Rebuild the database with the Latin1_General_CI_AS_KS_WS collation or create a new database – got this error when I was trying to mount a content database to an existing Web application in SharePoint using PowerShell command:

Mount-SPContentDatabase “Content.database” –WebApplication “http://mysite.company.com”

The specified database has an incorrect collation
The specified database has an incorrect collation – error

Error message clearly stated that the database is created with incorrect collation.

Resolution:

  1. Open SQL Server Management Studio and connect to database server.
  2. Select the database and right click -> Properties
  3. In the properties pane, Select Options
  4. Update the Collation drop down to Latin1_General_CI_AS_KS_WS and Ok.

    The specified database has an incorrect collation
    Database Properties

Note: If it says that the database is in a locked state and does not let you to update the collation, take the database to Offline mode first before changing the collation. After the change, bring it back to online mode.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Designer cannot display the item

You run into ‘SharePoint Designer cannot display the item’ error when you are trying to edit an existing workflow setup in Designer quite often when there is a windows update or update to .NET framework installed in your computer. In some cases it may also not allow you to create new workflows. Resolution: Clearing Designer […]

Read More

Windows security prompt. Connecting to SharePoint….

Users often run into this issue. Windows security prompt pops up every 15 minutes or so repeatedly trying to connect to SharePoint. No matter you enter credentials or cancel, user will be prompted for credentials again and again. SharePoint may not be the culprit all the time. List of things I check whenever I run […]

Read More

User with Contribute access gets access denied

Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions – check permission option. Every other person in the […]

Read More