Different SQL Collation co-exists in single machine

[Former Member]

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.

[JPReyes]

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

I don't think so each of them is a requirement.

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?

Correction... you can have 2 instance in the same DB but as far as i know they you won't be able to set different collations for each of them. I think you mean 2 separate DB's, if thats the case and its possible i can't see anything wrong as far as the box has enough resources.

Please correct me if I'm wrong

Regards

Juan