SAP Knowledge Base Article - Preview

3448236 - SWPM - Error: Your server uses collation: SQL_Latin1_General_CP1_CI_AS

Symptom

The customer was performing an OS/DB Heterogeneous System Copy. The customer installed first the (A)SCS instance on application server and afterwards proceeded to install the Microsoft SQL Server database instance in the database host, while executing the 'Define Parameters' phase, SWPM process stopped and the interface showed following error message:

Error:

Required MS SQL Server collation for the SAP system installation is: SQL_Latin1_General_CP850_BIN2 .
Your server uses collation: SQL_Latin1_General_CP1_CI_AS .
SOLUTION: Read the installation guide on how to set the correct server collation for the SAP system. 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP NETWEAVER System Copy to SAP NETWEAVER on DB-->SQL --> Microsoft SQL Server 2019 (RTM-CU23) (KB5030333) - 15.0.4335.1 (X64)-Developer Edition (64-bit)

Product

SAP NetWeaver 7.5

Keywords

SWPM, collation, BIN2, Microsoft SQL Server, Developer Edition, Enterprise Edition, System Copy, database refresh, backup, restore , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-MSS-INS , SQL Server Installation for SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.