Symptoms

When creating a database the following error occurs: 

Cannot configure database. Must declare the scalar variable "@sid". Inner Exception: SOAP Server Application Faulted

Cause

This issue might be caused by a case-sensitive SQL server or some issues with collation.

Resolution

In case the build of FlexiCapture is old, there might be some issues with collations, since old builds require Latin_General_CP1_CI_AS collation. Newer builds don't have such requirements.

In case if SQL server is case sensitive, it is necessary to switch it to the default insensitive option or correct the creating query, for example from @sid to @SID.