Can not Enable RBS because of SQL server collation for Sharepoint 2010
19/04/2011 1 Comment
Note: This is article contains possibility of one reason for this error.You can able to get this error other unrelated situations.)
When you try to enable after complete installation of RBS in sharepoint powershell console you getting belowed error:
Exception calling “Enable” with “0″ argument(s): “Must declare the scalar variable “@RBsId”.”
At line:1 char:13
First you think like me should i missing a parameter ? Answer NO! You are not! this fuction is parameterless.But whats happing ? I reflect the dlls and find out SPContentDatabase.RemoteBlobSettings.Enable() function call stored procedure of “dbo.proc_EnableRbs” in selected content database.And this stored procedure using @RBsId as internal parameter.
After working one day and countless install/uninstall attempt finally we found the problem is SQL Server Collation set “TURKISH_CI_AS” .And sharepoint 2010 has limitation with SQL collation .
You get more information form here:
Changing the server collation to Latin1_General_CI_AS_KS_WS fixes the issue .
In this moment you have two option as hardway you can try to rebuild master tables with correct collation and alter all content databases or as easy way you can reinstall SQL Server with corrent collation.