Sunday, July 16, 2017

SQL Server 2016 AG Setup Part 1–AD Installation and Configuration

  • Install Windows Server 2016

VirtualBox_PEGAAD_14_07_2017_19_36_08

VirtualBox_PEGAAD_14_07_2017_19_36_36

-> Select “Custom” for fresh Windows Installation

VirtualBox_PEGAAD_14_07_2017_19_36_48

VirtualBox_PEGAAD_14_07_2017_19_37_09VirtualBox_PEGAAD_14_07_2017_19_37_15VirtualBox_PEGAAD_14_07_2017_19_58_17

-> Install VirtualBox Guest Addon for AD server only, not  for subsequent SQL Server

VirtualBox_PEGAAD_14_07_2017_20_45_41

Configure Static IP, Change Server Hostname, as well as disable Windows Firewall

VirtualBox_PEGAAD_15_07_2017_09_09_17

VirtualBox_PEGAAD_15_07_2017_09_12_23

  • Feature Installation
    • AD: as domain Controller
    • .Net Framework: prerequisites for SSMS, to be used later

VirtualBox_PEGAAD_15_07_2017_08_23_02VirtualBox_PEGAAD_15_07_2017_08_23_48VirtualBox_PEGAAD_15_07_2017_08_24_12VirtualBox_PEGAAD_15_07_2017_08_24_26VirtualBox_PEGAAD_15_07_2017_08_24_46VirtualBox_PEGAAD_15_07_2017_08_24_59VirtualBox_PEGAAD_15_07_2017_09_01_57

  • Configure AD

VirtualBox_PEGAAD_15_07_2017_09_25_47VirtualBox_PEGAAD_15_07_2017_09_26_57VirtualBox_PEGAAD_15_07_2017_09_27_02VirtualBox_PEGAAD_15_07_2017_09_27_20VirtualBox_PEGAAD_15_07_2017_09_27_32VirtualBox_PEGAAD_15_07_2017_09_27_39VirtualBox_PEGAAD_15_07_2017_09_27_49VirtualBox_PEGAAD_15_07_2017_09_28_34VirtualBox_PEGAAD_15_07_2017_09_28_43