HCN SQL Specific Options for HCN Instances

  • Instance Name: must match those listed above (i.e. HCNSQL07 and ESP)
  • Service Account: must use the built-in System Account – Local System
  • Authentication Mode: must be Mixed Mode
  • SA Password: must adhere to the strong password rules (e.g. HcnTemp123$)
  • Collation Settings: leave as the defaults automatically detected by the Microsoft Installer