This document outlines the recommended steps for installing SQL Server (Express or Full) in preparation for installing Clinical / Pracsoft.
Follow the installation instructions that came with the Microsoft Product, deviating from those instructions only where the following points indicate.
Ensure you have checked the "Recommended System Requirements for MedicalDirector Products " BEFORE you begin.
Clinical / Pracsoft requires the installation of a secondary SQL instance for the Extensibility System and Plug-ins (ESP) feature. This instance will be created automatically by the HCN installer using SQL Server 2008 R2 Express.
If you would prefer the ESP instance to be installed using your full Microsoft SQL 2008, you will need to create a new instance named ESP by following the instructions below, replacing the instance name HCNSQL07 with ESP where appropriate.
If you choose to use full SQL 2005, SQL 2008, SQL 2012, or SQL 2014 with Clinical and/or Pracsoft, ensure you have applied the correct service pack prior to installing HCN Software;
o SQL 2005 - requires Service Pack 2
o SQL 2012 - requires Service Pack 1
o Instance Name: must match those listed above (i.e. HCNSQL07 and ESP)
o Service Account: must use the built-in System Account – Local System
o Authentication Mode: must be Mixed Mode
o SA Password: must adhere to the strong password rules (e.g. HcnTemp123$)
o Collation Settings: leave as the defaults automatically detected by the Microsoft Installer
Once both SQL Instances have been installed, please configure Network Configuration Protocols for both to accept connections via 'Shared Memory', 'TCP/IP' and 'Named-Pipes'. Ensure the SQL Client Configuration module on the Server has the Enable Shared Memory protocol option enabled. If you have installed both SQL Server instances (HCNSQL07 & ESP), please proceed with the instructions for your scenario, where these SQL Instances will be automatically detected and used.