| title | Incompatible Database Engine Server Collation (Upgrade Advisor) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 03/06/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | database-engine |
| ms.topic | conceptual |
| ms.assetid | 80f499d6-2c90-49eb-a5b3-0bb5b7faaa3b |
| author | maggiesMSFT |
| ms.author | maggies |
| manager | craigg |
Upgrade Advisor detected [!INCLUDEmsCoName] [!INCLUDEssRSnoversion] is using an instance of the [!INCLUDEssDEnoversion] that is configured to use an incompatible server collation.
| [!INCLUDEapplies] [!INCLUDEssRSnoversion] SharePoint mode. |
[!INCLUDEssRSnoversion]
Upgrade Advisor detected [!INCLUDEmsCoName] [!INCLUDEssRSnoversion] is using an instance of the [!INCLUDEssDEnoversion] that is configured to use an incompatible server collation.
[!INCLUDEssCurrent] [!INCLUDEssRSnoversion] SharePoint mode utilizes the SharePoint shared services architecture. SharePoint does not support [!INCLUDEssDEnoversion] 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 [!INCLUDEssDEnoversion] server collation is incompatible, upgrade is blocked.
The [!INCLUDEssDEnoversion] server collation property cannot be changed. You will not be able to complete an upgrade of [!INCLUDEssRSnoversion]. You will need to migrate your [!INCLUDEssRSnoversion] installation to a new server which is using a compatible server collation. For more information, see the following: