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.
