Spider Setup: SQL server collation

[#1]

Summary

Setup reports SQL Server collation as invalid.

Symptoms

Setup reports SQL Server collation as invalid.

Cause

As described in System Requirements - SQL Server the collation on the server must be a case insensitive (CI) collation.

Resolution

Change your collation to a case insensitive collation.

You can check your current settings by using this script:

SELECT
SERVERPROPERTY('Collation') AS ServerCollation,
SERVERPROPERTY('ComparisonStyle') AS ComparisonStyle,
CASE
WHEN (CAST(SERVERPROPERTY('ComparisonStyle') AS INT) & 1) = 1 THEN 'CI' ELSE 'CS'
END AS [Case],
CASE
WHEN (CAST(SERVERPROPERTY('ComparisonStyle') AS INT) & 2) = 2 THEN 'AI' ELSE 'AS'
END AS [Accent]