How to install multiple DB instances on SQL server

[Former Member]

Hi,

Client wanted to install multiple database (ECC,XI,BIW,EP)in single

server using SQL2005. CI is different server but datase is common server

with multiple databse instances.

My question is how to install second SQL database instance setup.exe

with diffrent named SID like first SQL installation . Or we just need to

copy binaries files only then install SAP databse instance.

for ex:I know oracle on Unix we need to copy only \oracle\C11\ora92

need to copy in \oracle\D11\ora92 , no need to setup setup.exe.

Like that in SQL2005 for second instance what we have to do. We just

copy installbles binary files or we have to setup.exe for second databse

also.

Please suggest .

Thanks

[Former Member]

Hello

On the SQL 2005 SP1 DVD from SAP you will find a file called SQL4SAP.VBS. Run this file and when it asks you for the instance name type the SID of the system you want install.

There may be a informational message about the use of named instances, you can ignore this message.

You may wish to carefully investigate the allocation of resources on the server that is to be used as the database server for ECC, XI, BI and EP.

Adequate resources such as memory, CPU and disk should be allocated to each database instance. CPU and memory can be changed dynamically. Disk resources can be changed, but this cannot be done online.

I also recommend you do not install SQL in this manner unless you are using Windows for Itanium systems or Windows for x64 systems. The hardware, database and the OS must be 64bit or you will have performance problems.

I recommend you refer to the installation guide and review OSS note:

879941 Configuration Parameters for SQL Server 2005

928839 SBO: Release planning for Microsoft SQL Server 2005

Good luck

N.P.C