Server Fault is a question and answer site for system and network administrators. 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 2005 collation SQL_Latin1_General_CP1_CI_AS. What are the potential issues we might face with MOSS 2007?

share|improve this question

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

Depends, does your company do anything in non-english?

share|improve this answer
Yes, some of our clients are in Canada, so we support English and French. – MDRoz Nov 20 '09 at 18:20

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.