Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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.