What SQL server version should be installed in BW 3.5?

[former_member188721]

Dear all,

What SQL server version should be installed in BW 3.5?

1.Does it must install with enterprice version? Or can it use standand version?

2.SQL 2000 is ok? or must use SQL 2005?

3.x32 is ok? or must use x64?

Best regards!

Brian

Edited by: brian allen on Jun 24, 2009 9:22 AM

[markus_doehr2 · Accepted solution]

> What SQL server version should be installed in BW 3.5?

>

> 1.Does it must install with enterprice version? Or can it use standand version?

Read the installation guide - Enterprise version only.

> 2.SQL 2000 is ok? or must use SQL 2005?

Both work but I would go for SQL 2005 (or even SQL 2008).

> 3.x32 is ok? or must use x64?

You should use 64bit wherever possible on new installations.

Makrus

[Former Member]

Hi Brian,

forget about SQL 2000 and IA32. Read [this|http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SAP_SQL2008_Best%20Practices_Part_I.docx] and decide yourself.

Sven