Create the server with Case-Sensitive collation?

     

You will get the following error when you attempt to extend a web site with the SPS server:

Must declare the scalar variable "@SiteId".

   

In the BizTalk Installation Guide (Multi server in this example) I found the following note:

   

If you will be using two namespaces that only vary by case, you must install the BizTalk Server databases with a case-sensitive collation. Examples of case-sensitive collations include binary and non-binary collations with case-sensitivity enabled. If this is not done, schema resolution will fail because XML is always case-sensitive.

   

So, being the hampered genius that I am, I installed my SQL Server with a default Case-Sensitive collation.

   

And of course I attempted to extend my SharePoint services to the default web site and got the above error.

   

After a some searching on the MS Support site, I finally found the answer.

Sharepoint 2.0 doesn't support case-sensitive collations!

   

Ok, how to recover? Considering that Sharepoint installs it's own database?

Re-install SQL Server is the only way to recover because the default collation impacts the Master and MSDB databases.

   

So, if you are installing SQL Server do not select case sensitive collation… recommended use:

Latin1_General_CI_AS_KS_WS.

- Case insensitive

- Accent sensitive

- Kana sensitive

- Width sensitive