Different SQL Collation co-exists in single machine
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.
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.