Today I wanted to install a trial version of Kentico on an existing SQL Server installation. During the setup I got the error message

ERROR: An error occurred: [DataConnection.ExecuteQuery]: Query: CREATE FUNCTION [Func_OM_Account_GetChildren] ( @currentAccountId int, @includeParent int ) RETURNS @result TABLE ( AccountID int ) AS BEGIN -- Recursively find all children of current account WITH Recursion(AccountID) AS ( SELECT AccountID FROM OM_Account a WHERE a.AccountMergedWithAccountID = @currentAccountID UNION ALL SELECT a.AccountID FROM OM_Account a INNER JOIN Recursion r ON a.AccountMergedWithAccountID = r.AccountID ) INSERT INTO @result SELECT AccountID FROM Recursion -- Include parent account ID in result IF @includeParent = 1 INSERT INTO @result VALUES (@currentAccountId) RETURN END : caused exception: Must declare the scalar variable "@currentAccountID". Incorrect syntax near ')'.

So, I took a look at the SQL and noticed that that Kentico CMS requires that you use case-insensitive (CI) collation.