Export (0) Print
Expand All

Incompatible Database Engine Server Collation (Upgrade Advisor)

Upgrade Advisor detected Microsoft Reporting Services is using an instance of the SQL Server Database Engine that is configured to use an incompatible server collation.

Applies to: Reporting Services SharePoint mode.

Reporting Services

Upgrade Advisor detected Microsoft Reporting Services is using an instance of the SQL Server Database Engine that is configured to use an incompatible server collation.

SQL Server 2014 Reporting Services SharePoint mode utilizes the SharePoint shared services architecture. SharePoint does not support SQL Server Database Engine configured for case sensitive or server collations or binary server collations. Incompatible collations include collations that are by default case sensitive or binary and a base collation that by default is compatible but has been configured with any of the following collation designators:

  • Binary

  • Case-sensitive

  • Binary-codepoint

Because the current SQL Server Database Engine server collation is incompatible, upgrade is blocked.

The SQL Server Database Engine server collation property cannot be changed. You will not be able to complete an upgrade of Reporting Services. You will need to migrate your Reporting Services installation to a new server which is using a compatible server collation. For more information, see the following:

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft