FrontDesk
(Server Software Installation) Ver. 1.0.1
www.frontdeskhealth.com
This document is the installation manual for installing the FrontDesk Server, Kiosk/Touch Screen, and License Management Tool applications. This document is intended for use by a
qualified Microsoft system and database administrator.
Copyright © 2010 J.L. Ward Associates, Inc. All Right Reserved.
TABLE OF CONTENTS
SERVER SOFTWARE INSTALLATION ... 4
Pre-Requisites ... 4
Installing Server on Windows XP Professional ... 5
Installing MS SQL Server 2008 Express ... 6
Installing the “FrontDesk Server” Application ... 8
Installing Server on Windows Server 2008 ... 12
Create New Website and Root Directory ... 12
Install SQL Server 2008 Express and FrontDesk Screener Server Applications ... 15
SERVER SOFTWARE INSTALLATION
Pre-Requisites
“FrontDesk Screener Server” is an ASP.NET web application with WCF service extension for Kiosk – Server communication.
Supported Operating Systems:
• Windows XP Professional SP3 or later
• Windows Server 2003 R2 or later .NET Framework:
• Microsoft .NET Framework 3.5 SP1 (included with installation) Web Server:
• IIS 5.0 (for Windows XP Sp3)
• IIS 6 or 7 with enabled ASP.NET feature.
• For Windows Vista, Windows 7, Windows Server 2008 the “Windows Communication Foundation HTTP Activation” feature has to be enabled.
Microsoft SQL Server 2008 Express SP1 for x86 platform (comes with installation):
• Windows Installer 4.5 or later (comes with installation)
• PowerShell 1.0 or later (comes with installation).
Windows Server 2008 “Windows PowerShell” has built-‐in server features, which need to be activated before running the installation package.
Supported Browsers:
• Internet Explorer 7 or 8 (Internet Explorer 8 recommended)
• Mozilla Firefox 3.5 Other required software:
• Adobe PDF Reader 8 or later
Installing Server on Windows XP Professional
1. Ensure that Internet Information Services (IIS) is installed. How to check:
ü Open [Start -‐> Control Panel -‐> Administrative Tools].
ü If IIS has been installed, an “Internet Information Services” item will show in this folder. This link opens the IIS Management Console window.
2. Configure IIS Website:
There are options how to install the “FrontDesk Behavioral Health Screener” application on the web server:
ü As a root folder of website.
ü As a virtual folder (application) into a website.
The “FrontDesk Behavioral Health Screener” application can work in both configurations.
Before installing “FrontDesk Behavioral Health Screener” on the server, the IIS server has to be configured and a folder needs to be created, where the application will be installed.
3. Open installation folder and run “setup.exe” to start installation. During the first run, the installer will check if the .NET Framework 3.5 SP1 is present on the local machine, and only then run the installer. A reboot is required after the .NET Framework installation.
4. Unless MS SQL Server 2008 is already installed on the target computer, click top button to install MS SQL Server 2008 Express SP1 with custom pre-‐configuration, required to run the FrontDesk Server application.
If the FrontDesk application has to use an already installed MS SQL Server 2008 (NOTE: This is not the Express version of the database), follow the steps below to configure the server manually:
ü FrontDesk application is configured to use SQL mode authentication mode. Enable
“Mixed Mode” authentication on the server.
ü FrontDesk Server installation will create a new “FrontDesk” database and all
required database objects. If “FrontDesk” database is already installed on the server, rename it and create a backup, or remove it. NOTE: Any re-‐installation of the product will not merge data automatically. Be sure to protect your data. This type of operation is not covered in this guide. Please contact your vendor for support.
Installing MS SQL Server 2008 Express
1. Click “Install SQL Server 2008 Express SP1” button on “FrontDesk Server Installer” window to start the database server installation.
2. Installer will check the system for the required “Windows Installer 4.5” and “PowerShell 1.0” programs, and will try to install them if they are absent.
3. In the dialog box, enter the name of the server to be installed and the password for the built-‐
in administrator login (‘sa’). Follow best practices and set a strong password for the “sa”
(superadmin) account. Do not change the system suggested “SQLExpress” server name, unless there are compelling reasons to do so.
NOTE: During the SQL Server 2008 installation process, a local “Administrators” group will be added to the “sysadmin” system role, to facilitate logging on to the server under Windows Authentication.
4. Click the “Next >” button to start the database server installation. During installation, a new window will appear on screen indicating installation progress.
5. Resulting message will show whether installation was completed successfully. If the installation failed, an error message will be displayed. In this case run the SQL Server 2008 Express installation manually (installation files are located on the FrontDesk distribution disk in the “SQLExpress” folder, or the latest version of SQL Server 2008 Express can be downloaded from the Microsoft website)
6. Click “Cancel” button to complete installation
Installing the “FrontDesk Server” Application
1. Select website where to install application.
2. Enter the virtual directory name (“FrontDeskScreener” by default).
The “Virtual Directory” field may be left empty for copying files into the website root directory.
3. Select the ‘Yes, encrypt sensitive data’ option, to ecrypt the database connection string with user password and machine key, which will be stored in the web.config file. These can be decrypted later using the ASP.NET utility “aspnet_regiis.exe.”
4. Click “Next >” on the “Confirm Installation” step to install application
5. Configure FrontDesk Server application connection settings. Select the SQL Server Instance, which will be used for the “FrontDesk Behavioral Health Screener” application.
A SQL Server login with the name ‘frontdesk_appuser’ will be created and a password for this login will be set. This login will be used for access to the database from the application.
If the “Encrypt” option was selected on the previous wizard step, then the connection string with user name and password, stored in the application configuration file, will be
encrypted. If not, it will be stored as open text.
Click the “Test Connection” button to check, if the connection to the server is working correctly. (If a connection error has occurred, then SQL Server 2008 Express did not install properly and needs to be re-‐installed manually). During this step, the setup program will create the “FrontDesk” database on the server.
Database installation script file is located on “C:\Program Files\Common Files\FrontDesk\Server\install_server.sql”.
6. Now run the application to test proper installation and perform the application registration.
Open a browser (see the list of supported browsers) and enter the application address (e.g.
“http://frontdesk.mycomanydomain.com/frontdeskscreener/”).
Login, using “su” built-‐in user account with “123” password. The program will require changing the password after login.
7. Testing the WCF service is required for connection to kiosks.
In the browser open the “/endpoint/kioskendpoint.svc” page in the installed FrontDesk Screener application, (full path will be
“http://frontdesk.mycomanydomain.com/frontdeskscreener/endpoint/kioskendpoint.svc”
). If the information page displays as shown below, then the WCF service was installed successfully.
Installing Server on Windows Server 2008 Create New Website and Root Directory
1. Open the “Server Manager” application from Start -‐> Administrative Tools -‐> Server Manager.
2. Click on the “Features” item in the right-‐side object tree and click on “Add Features” link.
3. In the “Features” list toggle on checkboxes for the next features:
ü .NET Framework 3.0 Features: .NET Framework 3.0, WCF Activation (both “HTTP Activation” and “Non-‐HTTP Activation”).
ü Windows PowerShell.
ü Windows Process Activation Service.
4. In the “Web Server (IIS)/Role Services” toggle on checkboxes for the following features:
ü Common HTTP Features: Static Content, Default Document, Directory Browsing, HTTP Errors.
ü Application Development: ASP.NET, .NET Extensibility, ISAPI Extensions, ISAPI Filters.
ü Management Tools:
• IIS Management Console.
• IIS 6 Management Compatibility: IIS 6 Metabase Compatibility, IIS 6 WMI Compatibility.
5. Install Selections.
6. Open Internet Information Services (IIS) Manager.
7. Add new website with your name (e.g. “FrontDesk”). Create new folder for the site (e.g.
C:\inetpub\frontdeskscreener). Set your site name. If the “FrontDesk Screener Server”
application will be installed as a virtual folder, this step can be omitted.
8. Preparation is completed and the installation of application and database server can commence.
Install SQL Server 2008 Express and FrontDesk Screener Server Applications
Installation procedures for of the SQL Server 2008 SP1 and ‘FrontDesk Screener Server’
applications are the same as for Windows XP Professional, described below. The only difference is that ‘run setup.exe as administrator’ is required.
NOTE: The “setup.exe” program will install .NET Framework 3.5 SP1. System restart is not required.