SQL Server 2012 installation

[JAMpe]

Hello,

I have a SAP instance in one server running with SQL Server 2012 (installed with SQL4SAP.bat and default instance). Now I want to install another SAP instance in the same server, How should I proceed?

If I run again SQL4sAP.bat will this replace the SQL server software (and database) installed before? Or I forced to use the same SQL Server software?

Regards,

JA

[former_member188883 · Accepted solution]

Hi JA,

If I run again SQL4sAP.bat will this replace the SQL server software (and database) installed before? Or I forced to use the same SQL Server software?

Select the named installation for this new setup. It should work. You may use existing SQL server software.

Hope this helps.

Regards,

Deepak Kori

[JAMpe · Accepted solution]

If I dont want to use existing SQL Server software, I should try a name installation this time?

Regards,

JA

[giri_ayyagari]

Hi J A

no worries about it, SQL4SAP.bat will detect existing instances and suggest (default) or allow you to enter instance name. go for it... 

hope this helps

-giri

[JAMpe]

If the SQL4SAP.bat suggest me the default and I continue with the installation, Will this install another SQL Server Software? (Which is what I want) or reuse existing software?

Regards,

[giri_ayyagari]

J A

Default means "default instance", if this has been used in the past, i strongly suggest user "INSTANCE" or "INSTANCE ID". once SQL Server install completes you can specify which instance you want to install during SAPINST process.

Hope this helps.

-Giri

[sivakumar_kilari3]

Hi,

Not required to install MS SQL server again, you can install another sap instance on same MS SQL server.

Thanks

Siva

[giri_ayyagari]

Sivakumar

When you use sql4sap it will take care of it. on the side note, you can in stall new SAP instance using 1 SQL instance with different Database Name (it's not best practice to do).

-giri

[sivakumar_kilari3]

When you use sql4sap it will take care of it

                      yes I know, I have do done 50 more times. and most of the people will do same

you can in stall new SAP instance using 1 SQL instance with different Database Name(it's not best practice to do).

What is the best practice ?

[giri_ayyagari]

This message was moderated.

[giri_ayyagari]

This message was moderated.

[JAMpe]

Hello,

You have the following options:

- If you want to use the same SQL Server Instance just start with SWPM and install the new SAP System (2 databases with 1 SQL Server instance).

- If you want to use a new SQL Server instance just start SQL4SAP.bat and chose a different SQL Server Instance name (each SQL Server Instance with only 1 database), then start SWPM and install the new SAP System.

Regards,

JA

[Former Member]

I believe you should use MCOD option you can achieve it by running installation master and  select MCOD when you have to define Database