Skip to Content
Author's profile photo Said Shepl

Installing SAP HA on SQL Part1: Install SQL Server Cluster.

We are present the installation of SAP System with a high availability for ABAP Instance:

This installation will be on Windows Server 2012 R2 as a platform and a SQL Server 2012 SP1 as adatabase level.

we well use Software provision manager 0.1 SP 06 and Kernel 7.2:

also we are divided this installation to the following Parts:

Part 1- Install SQL Server Cluster.

Part 1- Install First Cluster Node.

Part 2- Install DB instance.

Part 3- Install Additional Cluster Node.

Part 4- nstall Centeral Instance.

Part 5- Install dialog Instance.

we will start directly now in part 1:Install SQL Server Cluster.

First Step: SQL Server Failover Cluster Installation.

We will open SQL Server 2012 DVD and select setup —> New SQL Server Failover Cluster Installation

SQL Cluster 00.PNG

SQL Cluster 01.PNG

Enter The Product Key and select Enter.

Select – I accept the license terms.SQL Cluster 02.PNGSQL Cluster 03.PNGSQL Cluster 04.PNGSQL Cluster 05.PNG

Select SQL Server Feature Installation.

SQL Cluster 06.PNG

Select the following Instance Features:

SQL Cluster 07.PNG

Select also Managment Tools in Feasure:

SQL Cluster 08.PNGSQL Cluster 09.PNG

Put the SQL Server Network Name (as SQL Group)SQL Cluster 10.PNGSQL Cluster 11.PNGSQL Cluster 12.PNGSQL Cluster 13.PNG

Select Cluster Disk which is specified to SQL Server.

SQL Cluster 14.PNG

Put The IP Address for SQL Server.

SQL Cluster 15.PNG

SQL Cluster 16.PNG

Don’t forget to select the collation tab and select the type for collation: (SQL_Latin_General_CP850_BIN2).                                        

SQL Cluster 17.PNG

Select Mixe Mode(SQL Server Auth and Win Auth) to Access SQL by uesing any Win or SQL User as you required.

SQL Cluster 18.PNGSQL Cluster 19.PNGSQL Cluster 20.PNGSQL Cluster 21.PNGSQL Cluster 22.PNGSQL Cluster 23.PNGSQL Cluster 24.PNG

We will Continue in a secand step install add node SQL server failover cluster.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.