AuthorIT cannot establish a connection to the SQL Server database "" on the server "".

Problem

When trying to connect to a SQL Server library for the first time the following error occurs:

AuthorIT cannot establish a connection to the SQL Server database "" on the server "".

An 'ODBC -- Call Failed' error has been caused by:

S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SYSOBJECTS'. (Error 208)

37000: [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. (Error 16945)

Reason

SQL Server has been installed with a case sensitive collation order. AuthorIT requires a case insensitive collation order

Solution

During the SQL Server installation, the following options are available. Select a case-insensitive collation.

Microsoft has further documentation on SQL Server Collations on their website.