Eclipse.net Installation Guide - Micro Lib

1 Installation Guide Installing the very latest version of eclipse onto a new server Installation Guide ID: 217 Version Number: Date: 18/02/2016 1 Table of Contents Introduction and Pre-requisites .. 2 Minimum system requirements and 3 Guide Pre-requisites .. 4 Chapter 1: Installing SQL server .. 5 Chapter 2: Installing the Application .. 8 Chapter 3: Entering the Application Settings .. 12 License Tab .. 12 Proxy Tab .. 13 Library and Scheduler Database Tabs .. 14 Database Upgrade .. 16 Chapter 4: IIS Settings .. 16 Authentication Settings .. 16 Application Pool Settings .. 17 Active Directory (Optional) .. 20 Email Reminders (Optional).

2 23 Chapter 5: Post Installation Tasks and Considerations .. 24 Database Conversion .. 24 Silverlight Installation .. 24 Browser Settings .. 24 IE Favourite / Shortcut .. 24 Library Quick Start Guide .. 24 Frequently Asked Questions .. 25 Installation Guide ID: 217 Version Number: Date: 18/02/2016 2 Introduction and Pre-requisites This Guide explains how to install eclipse or onto a new server . The latest version includes both a back end and front end that is based on Microsoft Silverlight. The minimum hardware and software requirements are shown below. Before starting, ensure that both the server and client computers meet these requirements.

3 This document is mainly split between two sections; installing the SQL server and installing the application. Although it is common that these are installed onto the same server (as shown in Fig below) this is not a requirement. It is possible to have SQL server installed onto one and the application installed onto another like in Fig below. The latter is common in environments where there is an already existing SQL server installed or environments where the application server is available on the internet and is in a DMZ. Fig : SQL and application on the same server . Fig : SQL and application on separate servers. Installation Guide ID: 217 Version Number: Date: 18/02/2016 3 Minimum system requirements and Compatibility The table below shows the computer requirements for the server hosting the application and the SQL database.

4 Component Requirement Computer and Processor gigahertz (GHz) or faster x86 or x64 Dual Core CPU or better Memory (RAM) 4 gigabytes (GB) RAM (8GB is highly recommended) Hard Disk 10 gigabytes (GB) available server Operating System Windows server 2008 R2 Windows server 2012 / R2** Any version of windows server Core is not supported SQL server Express or Full Microsoft SQL 2005* Microsoft SQL 2008 / R2 Microsoft SQL 2012 Microsoft SQL 2014 *SQL 2005 express has a 2 gigabyte (GB) database limit. Microsoft .NET Frameworks, including latest Service Packs .NET .NET .NET .NET Other An Internet connection is required on the server for product activation and to take full advantage of functionality.

5 The table below shows the requirements for the client computers accessing the software. Component Requirement Computer and Processor gigahertz (GHz) Dual Core CPU or better Memory (RAM) 1 gigabyte (GB) RAM Client Operating System Windows Vista Windows 7 / x64 Windows 8 Browser Internet Explorer 7 + Installation Guide ID: 217 Version Number: Date: 18/02/2016 4 Guide Pre-requisites Before starting to follow the instructions in this Guide , it is advisable to ensure that the prerequisites in the table below have been met. Making sure that the below has been carried out before the update is started, increases the likelihood that the Installation will be successful and issue-free.

6 Prerequisites IMPORTANT! This Guide details how to install SQL server if it is not already installed. (See the notes in the introduction above). However, if an existing SQL server is being used then ensure that the following component is installed: SQL server Full Text It is imperative that this is installed as otherwise searching will not function. In addition, although the Management studio is considered an optional component, having this installed when needing to troubleshoot an issue (or taking backups/running scripts) is very helpful. Make sure the latest service packs and windows updates have been installed on the application and SQL server . Make sure the appropriate roles and services are installed before running the Installer.

7 Have a copy of the Installation files / disc to hand. Install Microsoft .NET Framework onto the application server . Ensure that the latest version of Microsoft Silverlight is installed onto both the client machines and server accessing the application. The user number and postcode are required for product activation so make sure that these are known beforehand. Make a note of the default administrator login for the application. Username: administrator Password: microlib They will be needed in this Guide ! Installation Guide ID: 217 Version Number: Date: 18/02/2016 5 Chapter 1: Installing SQL server Any version and edition of SQL above 2000 is supported for use with the library system.

8 Be mindful however, that SQL 2005 employs a 4GB database limit. This means that if this limit is reached, no further transactions ( books circulated, resources added) will be stored in the data and will be discarded. As a result, it is recommended to use a full version of SQL server or an express version that has a higher database limit, such as 2008 or 2012. Our Installation disc includes SQL server 2012 express so the steps below explain how to install the SQL engine from our Installation disc. Should you wish to install SQL yourself from scratch, see the dedicated Guide here. 1. Insert the DVD disc into the disc drive and the splash screen should automatically be shown.

9 Fig 2. Click Install SQL server 2012 Express Database (x86 / x64) and a command prompt will open. Installation Guide ID: 217 Version Number: Date: 18/02/2016 6 Fig NOTE The default SA account/login password is shown in the command prompt window. Take a note of this password as you will need it later in the Installation . d0tNETl1bPWD 3. Press any key on the keyboard to continue. You will now be asked whether you wish to install the 64-bit version of SQL. Should you type yes (or y) then the 64-bit version will be installed. If you type no (or n) then the 32-bit version will be installed. Fig Installation Guide ID: 217 Version Number: Date: 18/02/2016 7 4.

10 The Installation of SQL will then begin. Fig When the Installation has finished, you may want to install the SQL Management studio, which is a utility that can be used to administer your SQL Installation and databases. To install the Management studio, you can run the installer from the Installation disc or download this free, from Microsoft. To install the SQL Management studio from our Installation disc, click one of: SQL server Management Studio x86 SQL server Management Studio x64 After the Management studio has installed, you should be able to log into the SQL instance we created earlier (Servername\MLSECLIPSE) using the sa account and password as above. Installation Guide ID: 217 Version Number: Date: 18/02/2016 8 Chapter 2: Installing the Application The instructions in this chapter explain how to install the application once SQL server has been installed.