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