Differences

This shows you the differences between two versions of the page.

--- emis_systems_administrator_manual [2023/10/18 14:47] – [Web Server (IIS)] ghachey
+++ emis_systems_administrator_manual [2024/04/10 05:34] (current) – [Deploy the Application] ghachey
@@ Line 21: / Line 21: @@
 Currently only the Windows operating system is supported. The application can be installed on any recent version of the Windows operating system.
-  * Windows Server 2022, 2019, 2016
+  * Windows Server 2022 (recommended), 2019, 2016
   * Windows 11, 10
@@ Line 30: / Line 30: @@
 The only database engine currently supported is Microsoft SQL Server (SQL Server) with most deployments tested with the following versions:
-  * SQL Server 2022 (including Express Edition)
+  * SQL Server 2022 (including Express Edition) (recommended)
   * SQL Server 2019 (including Express Edition)
   * SQL Server 2014 (including Express Edition)
@@ Line 38: / Line 38: @@
 There is no need for an expensive license, the Express edition which is freely available will work fine for most small countries. If you don't have already a commercial license download the free version [[https://www.microsoft.com/en-us/download/details.aspx?id=29062|MS SQL Server Express]]. Any of the files would have the required minimal database engine but might has well download the 64bit full version called //ENU\x64\SQLEXPRADV_x64_ENU.exe//. Double click and follow through the installation. Choosing the default values is a good start and reboot the system when done.
-<note tip>For better backup plans of the SQL database (e.g support for compression) the paid version is recommended.</note>
+<note tip>For better backup plans of the SQL database (e.g support for compression) the paid version is recommended. However, we have a nice PowerShell script combined with a Windows Schedule Task that can easily automate DB backups also.</note>
 ==== Install .NET Framework ====
-Install [[https://www.microsoft.com/en-us/download/details.aspx?id=48130|.NET 4.6 Framework]] by downloading the web installer and running it, of course a good Internet connection will be required.
+The projects in the whole solution target either 4.6, 4.6.1 and 4.6.2. The migration to target 4.8 in each project is on-going. But the compiled solution runs fine in the default .NET that comes with the operations system and there should be no need to install another .NET version.
-<note tip>The installation might not proceed with a message that this or a later .NET framework is already installed on the computer. This is normal.</note>
 ==== Create Account to Run the Application ====
@@ Line 162: / Line 160: @@
 On your local system, you will need to :
   * Create a folder for this (e.g. C:\fileDb )
-  * Make sure that the account running the EMIs apppool has CRUD and Create Folder permissions to this folder
+  * Make sure that the account running the EMIS apppool has CRUD and Create Folder permissions to this folder
   * Set the web.config entry
@@ Line 477: / Line 475: @@
   - Create ssh-keys with command ''ssh-host-config'' (mostly defaults are fine though some linux SSH experience is valuable here)
   - Do any edits to the ''/etc/sshd_config'' if you need (like changing SSH listen port)
-  - Start the SSH service with command ''net start sshd''
+  - Start the SSH service with command ''net start cygsshd''
   - Configure the backuppc user encryption keys with the command ''ssh-user-config''
   - Test ssh access with ''ssh backuppc@localhost'' and ''ssh backuppc@hostname''
@@ Line 502: / Line 500: @@
 === Automate daily SQL database exports ===
-This unfortunately can not "easily" be done with SQL Server Express (free edition), though there are ways. Here the steps outlined are with a licensed version of SQL Server.
+There are two ways to achieve this:
+  * The expensive paid version of Microsoft SQL Server can easily produce nightly backup plans from the UI.
+  * The free version of Microsoft SQL Server Express does not support this feature. However, it is not difficult to produce a script to do the backup and execute the script using the Windows Task Scheduler. This is the method used in most deployment of Pacific EMIS using a custom script on the server.
 === Automate daily JasperReports exports ===