SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, our internal hosting group uses the default SQL Server collation SQL_Latin1_General_CP1_CI_AS. What are the potential issues we might face with MOSS?

share|improve this question
up vote 3 down vote accepted

The server collation must be configured for case-insensitive, which is ok in your case.

If you use SharePoint itself to create its different databases, it will set the required collation automatically. However, if you use precreated databases - make sure you to change the collation manually. Otherwise, SharePoint won't even let you use those databases.

share|improve this answer

Will they actually change the collation? If SharePoint is creating the databases it will set the collation and override the server defaults. This was my experience in a previous environment with SharePoint using a large shared SQL Ent server.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.