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] |
