Configuring a Full Microsft SQL Server
If you do not have full SQL 2005, 2008 or 2008 R2, or you want to use the free Microsoft SQL Express 2005, please bypass these instructions.
If you have a full SQL Server licence and want to use it rather than the supplied 2014 SP3 Express Edition, the correct service pack for the SQL Server version must be installed:
- SQL 2005 requires Service Pack 2.
- SQL 2008 requires Service Pack 2.
- SQL 2012 requires Service Pack 1.
Install the Server role on your dedicated server, even if you want to use your own full SQL Server and not the supplied 2014 SP3 Express Edition. This creates the necessary databases and sets up the document management system.
Configure your full SQL Server with the following settings:
- Instance Name
- Must match one of 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.
- Collation Settings
- Leave as the defaults automatically detected by the Microsoft Installer.