Configuring a Full Microsoft SQL Server

Install SQL Server and its service packs, then configure it.

These instructions apply only to full SQL Server installations. They do not apply to the supplied Microsoft SQL 2019 Express Edition.

Install the server role on your dedicated server. This creates the databases and sets up the document management system.

Install the correct service pack for the SQL Server version.

Configure SQL Server with the following settings:

Instance Name
Must be HCNSQL07 or ESP.
Service Account
Use the built-in system account Local System.
Authentication Mode
Select Mixed Mode.
SA Password
The password must adhere to the strong password rules.
Collation Settings
Use the default settings automatically detected by the Microsoft Installer.