SharePoint User Group UK

Hi,

When i am intalling Moss 2007 enterprise to create a new farm on our sql 2000 server. It fails when creating the database. In the error log this explaination comes up:

The specified SQL Server instance has invalid sort order Latin1_General_BIN. Choose a server instance that performs case-insensitive and non-binary comparisons.

Does anyone know how to rectify this problem?

Please help.

SharePoint is very particular on the collation sequence and sort order SQL Server must be installed with: if you choose the wrong one during SQL Server install one of two things will happen: either it will not install at all (which is what you have seen), or it will fail during operation as the system databases (especially tempdb) have an incompatiable collation sequence for SharePoint.

The only option I am aware of at this point is to de and re-install SQL Server with the correct collation sequence.

Thats great Andy, thanks for your help.

I had to uninstall and re-install SQL and have made it work with non-binary and case-insensitive sort order option on our dev server but will have to look at rebuilding the production main database to handle this, fingers crossed(and plenty of research/planning:) that it works with other applications that reference the database.

Cheers again!

Is it possible to create another SQL server instance and use that one, or change the collation order on the current one? I suppose this modifies the master database.

Ravie.

Hi,

I do not believe it is possible to change the collation sequence on system databases (master, tempdb, msdb) etc.

You have to install with the correct sequence to start with.