cancel
Showing results for 
Search instead for 
Did you mean: 

ERP 6 EHP 3/ NW 7.0 on MSSQL 2012

former_member206857
Active Participant
0 Kudos

Hi All,

As most of you know, Microsoft pulled it's mainstream support for SQL 2008 in July.

We now need to make some decisions. Right now, we aren't ready to move to a newer EHP for ERP, so the question asked to me is, can

ERP 6 Ehp 3 run on MSSQL 2012.

I started looking at the PAM for ERP 6 EHP3, it doesn't list any details.

So I looked at the PAM for NW 7.0  https://websmp210.sap-ag.de/~sapidb/011000358700001225132009E

This PAM includes all EHP's.

I see support for SQL2012 on Win 2008/2012 and see note 1651862

Our NW is 7.0 SP 17, NO EHP's.

Note says this

Required minimum SAP Netweaver Support Package Stacks (SPSs) for SQL Server 2012 (SAP ABAP, SAP ABAP+JAVA stacks)

SAP NETWEAVER 7.0 - SPS 26 (SAP BASIS 26, SAP BW 28)

Anyways else have this irritation?


Accepted Solutions (0)

Answers (2)

Answers (2)

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Joshua

Yes, there is a requirement to have a certain level of SPS for MSSQL 2012.

If there is no plan to update the system from EHP 3 to EHP4 (atleast) then get the system patched to a required level. If that is not met then you are more likely to encounter issues like these.

http://scn.sap.com/thread/3561437

I see that starting from EHP4 is supported with MSSQL 2012.

https://service.sap.com/sap/support/pam?hash=pvnr%3D01200615320900003195%26pt%3Dt%257CPLTFRM%26ainst...

I would also suggest you to read this SAP note if you are planning to move to MSSQL 2012

1676665 - Setting up Microsoft SQL Server 2012

Regards

RB

former_member188883
Active Contributor
0 Kudos

Hi Joshua,

As per PAM, Extended planned support for MSSQL 2008 is upto 2019. You may check the Details link under MSSQL 2008 within PAM

Maintenance Type

Date

Comment

Additional Information

End of standard vendor support (regular maintenance phase)07/08/2014Planned Date

End of extended vendor support (additional maintenance phase)07/09/2019Planned Date

Hope this helps.

Regards,

Deepak Kori

former_member206857
Active Participant
0 Kudos

You are correct Kori, but we don't want to pay for extended services...

former_member188883
Active Contributor
0 Kudos

Hi Joshua,

In order to have your SAP system on MSSQL 2012 , you need to work on SAP as well DB updates.

Please evaluate the cost  for updating entire SAP system versus cost you will pay to SAP for extended maintenance. This will help you and your management to take a call on which method of go with.

Once you decide for an upgrade then suggestion would be to update to EHP7 / MSSQL 2012 / Windows 2012

Major advantange:

1) You landscape will be on the latest support OS/DB platform

2) You will be under mainstream support upto 2020

3) You may utilize new features available under EHP7. Check Solution browser for more details

   www.sapsolutionbrowser.com

Hope this helps

Regards,

Deepak Kori