Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Different SQL Collation co-exists in single machine

Hi all,

I have a scenerio here.

My company is going to install SAP IDES 6.0 system using MS SQL Server 2005 as database layer on machine A.

In addition also plan to install SAP BPC 7.0 on Microsoft Platform which also using MS SQL Server 2005

as database layer on the machine A.

As far as I know, SAP IDESC system installation would required

SQL Collation: SQL_Latin1_General_CP850_BIN2

while BPC 7.0 required SQL Server installed using SQL Collation: Latin1_General_CI_AS collation.

Question:

1. Is it a way for BPC 7.0 and IDESC system co-exists using single collation (either using

SQL_Latin1_General_CP850_BIN2 OR Latin1_General_CI_AS

2. If No.1 is not possible, does that mean it will required 2 instance of SQL Server and what are the

complications of having 2 instance install?

Appreciate any feedback.

Thanks.

Former Member
Not what you were looking for? View more on this topic or Ask a question