SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP3

This blog describes how you can install the following products on SQL Server 2012 EHP2 for SAP CRM 7.0 EHP6 for SAP ERP 6.0 EHP2 for SAP SCM 7.0 EHP2 for SAP SRM 7.0 SAP NetWeaver 7.0 including EHP3 In addition, please always read SAP Note 1676665  – Setting up Microsoft SQL Server 2012 (Login… Read more

SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP1

This blog describes how you can install the following products on SQL Server 2012 SAP CRM 7.0 Support Release 1 SAP ERP 6 EHP4 Ready – Support Release 1 SAP SCM 7.0 Support Release 1 SAP SRM 7.0 Support Release 1 SAP NetWeaver 7.0 including EHP1 Support Release 1 In addition, please always read SAP… Read more

SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP2

This blog describes how you can install the following products on SQL Server 2012 EHP1 for SAP CRM 7.0 EHP5 for SAP ERP 6.0 EHP1 for SAP SCM 7.0 EHP1 for SAP SRM 7.0 SAP NetWeaver 7.0 including EHP2 In addition, please always read SAP Note 1676665  – Setting up Microsoft SQL Server 2012 (Login… Read more

SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0

This blog describes how you can install the following products on SQL Server 2012 SAP CRM 5.0 Support Release 3 SAP ERP 6.0 Support Release 3 SAP SCM 5.0 Support Release 3 SAP SRM 5.0 Support Release 3 SAP NetWeaver 7.0 Support Release 3 In addition, please always read SAP Note 1676665  – Setting up… Read more

SQL Server 2012 Enterprise Editions

Version 2.0. Please note additional comment in the section: ‘How do we change between different releases’ In this blog we want to shed some light into a topic that can develop into some confusion and which at the end might also cause some performance issues with customers running SQL Server 2012 with their SAP Netweaver… Read more

SAP on SQL Server Security Whitepaper Released

 In response to requests from customers and partners we have documented a security procedure that has been successfully deployed at many customer sites over the last few years. This document also includes some very interesting comparisons between UNIX Security and Windows Security.  This Security Guide describes how to use Microsoft Active Directory and Windows tools… Read more

SQL Server 2012 Column-store support for SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SQL-Server-2012-Column-store-support-for-SAP-BW/ba-p/367399 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SQL Server 2012 introduced an additional storage format for data. Besides the normal row-oriented store, there is a column-oriented store as well (like in SAP HANA). In… Read more

Microsoft and SAP NetWeaver – step by step up to the cloud – Part III : some thoughts about automated Windows patching

Microsoft Private Cloud for SAP NetWeaver Automated Windows Patching in a Microsoft Private Cloud for SAP High-level Overview   First let’s describe the basic idea which is pretty simple. The following four screenshots will give a very brief overview. Details are described in the sections further down in this blog. System Center Orchestrator 2012 was… Read more

SQL Server 2012 AlwaysOn – Part 7 – Details behind an AlwaysOn Availability Group

[Edit] You can find the summary of the complete series here. Version 2.0 – Correcting Failure Condition Level explanations After having created our first Availability Group, we now want to go behind the scenes and into the details of what does happen when creating an Availability Group. As we discussed in earlier parts, WSFC plays… Read more

How to Setup a Dedicated SAP Application Server to DB Server Network

   What is a Dedicated SAP Application Server to DB Network & Do I Need One? A dedicated SAP Network is a network interface that is separated from the normal “Public” user network and carries only network traffic between the SAP application servers, the (A)SCS and the SQL Server database.  This blog discusses why and… Read more