Skip to Content
avatar image
Former Member

SAP ME - Can you use a single MSSQL instance on a single server?

Hi,

We need to build a demo system with the minimum of hardware so would like to use just one server.

The build would be Netweaver 7.4, ME 15 & MII 15 Using SQL 2012 as the database.

The question is, can I use a single instance of SQL or do I need to install two ? One for netweaver and one for ME ?

The ME database install guide states the following warning:

CAUTION

SAP ME does not use the same collation as the SAP NetWeaver database and server. Do

not use the SQL4SAP.vbs provided with MSSQL software to install the SQL Server database

software.

Does this mean I would install one instance for Netweaver using SQL4SAP.vbs and a second one (using a different port number) for ME using the standard installer ?

Or can I install just one database engine instance and configure the collation for each database individually ?

Also what about any of the other settings, eg Filestream and the XA install ?

Thanks for any guide that you can give.

Kevin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 06:39 PM

    Hi

    SAP Note 1409811 details the minimum requirements.

    http://service.sap.com/sap/support/notes/1409811

    Thanks


    Steve

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Steve, why didn't I think of look there! Thats what happens when you have a break over new year.

      So basically the answer is for MSSQL you have to install separate instances of the database engine.

      Thanks for a really quick response.

      Kevin

  • Jan 06, 2015 at 07:26 PM

    Hi Kevin,

    We have this exact scenario on one of our internal sandboxes. Install a single SQLServer 2012 (we installed Enterprise version) instance and create the NW, ME WIP, ME ODS, and ME GODS databases separately, with different collations. We also have XA configured on the server, don't know about Filestream.

    We are running a 2 CPU 8GB VM instance, I would recommend at least 12GB as 8 is minimal.

    Regards, Steve

    Add comment
    10|10000 characters needed characters exceeded