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

[Former Member]

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

[williamson · Accepted solution]

Hi

SAP Note 1409811 details the minimum requirements.

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

Thanks

Steve

[Former Member · Accepted solution]

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

[former_member196557]

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