Difference between revisions of "Database and Server Set Up"

From EHS Help
Jump to: navigation, search
(→‎Web Service URL's: removed need for NBID.org)
(Updated URLs & removed superfluous information)
Line 2: Line 2:
  
  
−
==Target Audience==
+
<!-- ==Target Audience==
  
 
These instructions are of a technical nature & intended for trust level IT staff & requires experience of:
 
These instructions are of a technical nature & intended for trust level IT staff & requires experience of:
Line 8: Line 8:
 
*MS SQL Server - creating databases and running scripts,
 
*MS SQL Server - creating databases and running scripts,
 
*TCP/IP - Installation and configuration of windows services, TCP/IP ports and firewall configuration
 
*TCP/IP - Installation and configuration of windows services, TCP/IP ports and firewall configuration
 +
-->
  
−
==Database Setup==
+
==Setup the Database==
  
 
#Create an empty SQL Server Database  
 
#Create an empty SQL Server Database  
−
#Download the '''IBID Server MSSQL Script''' zip file from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' section. Unzip to access the database creation script.
+
#Download '''Aquila CRS Database Script for MS SQL Server''' from [https://www.evolutionhealthcaresystems.co.uk/downloads#aquila-install www.evolutionhealthcaresystems.co.uk/downloads] (login required).
−
#Using your tool of choice (usually MS SQL Server Management Studio) run the SQL script against the empty database to create the tables, views and to pre-populate the data.
+
#Unzip to access the database creation script.
 +
#Using your tool of choice (usually MS SQL Server Management Studio) run the SQL script against the empty database to create the tables, views and to pre-populate configuration data.
 +
#Create a new login that the application server can use to access the database.  See [[Creating a SQL Server Login]] for details.  Alternatively you can use Windows Authentication for the application server which does not require an SQL login.
  
−
If you're planning on using SQL Authentication then you need an SQL Login for AquilaServer:
+
Make a note of the server name, database name & login details for the application server installation.
−
#Create a new login for that database that the app-server can use to access the database.  The login is for the ibid-server, not individual users, so requires full access to the IBID database.  See [[Creating a SQL Server Login]] for details.
+
−
 
+
−
For the installation of the app-server later you will need to know the server name of your SQL server, database name.  If using SQL Authentication, you will also need the user name & password you just created.
+
  
 
==Application Server Installation==
 
==Application Server Installation==
  
−
Download the '''IBID Server Application Setup''' from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' section.
+
#Download the '''Aquila CRS Server vN.N.N Full Install''' from [https://www.evolutionhealthcaresystems.co.uk/downloads/#aquila-install www.evolutionhealthcaresystems.co.uk/downloads] (login required).
−
 
+
−
#Unzip the AquilaServer_setup file
+
 
#Run the installation wizard.
 
#Run the installation wizard.
 
#Enter your server and database name, click Next.
 
#Enter your server and database name, click Next.
−
#For ''SQL Authentication'' mode enter your SQL userid and password, click Next. For ''Windows Authentication mode'' leave both fields blank and click Next.
+
#For SQL Authentication mode enter your SQL userid and password. For ''Windows Authentication mode'' leave both fields blank.  Then click Next.
−
<!---
+
−
#Edit the '''Connection String''' parameter during the installation.  Replace the items in italics with your own settings
+
−
## ''for SQL Authentication mode'':
+
−
## AnyDAC?AuxDriver=MSSQL;Server=''SERVERNAME'';Database=''DATABASENAME'';UserID=''USERID'';Password=''PASSWORD'';
+
−
## ''for Windows Authentication mode'':
+
−
## AnyDAC?AuxDriver=MSSQL;Server=''SERVERNAME'';Database=''DATABASENAME'';Integrated Security=SSPI;
+
−
-->
+
 
#Continue the installation wizard until complete.
 
#Continue the installation wizard until complete.
−
#Open the port 8099 on your servers firewall.  (The port number is changeable if necessary)
+
#Open the port 8099 on your servers firewall.  (The port number is changeable if necessary).
−
##The settings filename is aquilaserver.ini if you need to make any changes - restart the service once changes have been made to this file.
+
##The settings filename is aquilaserver.ini if you need to make any changes - always restart the AquilaServer service once changes have been made to this file.
−
#Check ''services.msc'' to ensure that the AquilaServer service has been started and is set to Automatic.
+
 
 +
<!--
  
 
'''Server URL''':  The Server URL is used to allow the desktop software to connect to the database. All users of the IBID application will need to input this on their first login.  It is formatted as follows:
 
'''Server URL''':  The Server URL is used to allow the desktop software to connect to the database. All users of the IBID application will need to input this on their first login.  It is formatted as follows:
Line 45: Line 37:
  
 
If the application server is installed on a server called TRUSTSRV01 and is listening on the default port of 8099, then your Server URL is '''http://trustsrv01:8099/bin'''
 
If the application server is installed on a server called TRUSTSRV01 and is listening on the default port of 8099, then your Server URL is '''http://trustsrv01:8099/bin'''
 +
 +
-->
  
 
==IBID Software Installation==
 
==IBID Software Installation==
  
−
#Download the '''AquilaCRS''' setup file from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' > ''IBID Desktop Software'' section.   
+
#Download the '''Aquila CRS Desktop vN.N.N Full Install''' from [https://www.evolutionhealthcaresystems.co.uk/downloads/#aquila-install www.evolutionhealthcaresystems.co.uk/downloads] (login required).   
−
##Use either '''per-user''' or '''all-users''' - see [[AquilaCRS Pre-requisites]] for information on each type.
+
#Run the installation program and enter the URL of the application server when prompted. It takes the form of '''http://''applicationservername'':8099/bin'''  (The Server URL can also be entered on the application login screen).
−
#Run the installation program and enter the Server URL when prompted.
+
−
##The Server URL is also available on the login screen by clicking the ''Connection'' link
+
  
 
<!--[[File:Ibid_admin_login.png]]-->
 
<!--[[File:Ibid_admin_login.png]]-->

Revision as of 08:19, 7 July 2017

This is a Technical (IT) Instructions topic


Setup the Database

  1. Create an empty SQL Server Database
  2. Download Aquila CRS Database Script for MS SQL Server from www.evolutionhealthcaresystems.co.uk/downloads (login required).
  3. Unzip to access the database creation script.
  4. Using your tool of choice (usually MS SQL Server Management Studio) run the SQL script against the empty database to create the tables, views and to pre-populate configuration data.
  5. Create a new login that the application server can use to access the database. See Creating a SQL Server Login for details. Alternatively you can use Windows Authentication for the application server which does not require an SQL login.

Make a note of the server name, database name & login details for the application server installation.

Application Server Installation

  1. Download the Aquila CRS Server vN.N.N Full Install from www.evolutionhealthcaresystems.co.uk/downloads (login required).
  2. Run the installation wizard.
  3. Enter your server and database name, click Next.
  4. For SQL Authentication mode enter your SQL userid and password. For Windows Authentication mode leave both fields blank. Then click Next.
  5. Continue the installation wizard until complete.
  6. Open the port 8099 on your servers firewall. (The port number is changeable if necessary).
    1. The settings filename is aquilaserver.ini if you need to make any changes - always restart the AquilaServer service once changes have been made to this file.


IBID Software Installation

  1. Download the Aquila CRS Desktop vN.N.N Full Install from www.evolutionhealthcaresystems.co.uk/downloads (login required).
  2. Run the installation program and enter the URL of the application server when prompted. It takes the form of http://applicationservername:8099/bin (The Server URL can also be entered on the application login screen).


The setup program accepts a number of command line switches that may be useful to a system administrator to run the install silently, or to integrate into a larger deployment script. See Setup Program Command Line Switches for more information.

First time setup of IBID

Designated system administrators at each site will receive an initial administrator level login separately.

  1. Go to the IBID Installation and Setup page.
  2. Register your IBID System:
    1. Enter your IBID Unit ID and click Register. This will open IBID features in the software and also test connectivity to the National Database.

System administrators can now create additional standard users. It is highly recommended that the system administrator creates another administrator level user for themselves.

Desktop software installation & users

Repeat #IBID Software Installation to install the iBID software wherever you need it.

To discuss any aspect of the installation please raise a ticket on our helpdesk system, or call 01964 503400.

Web Service URL's

AquilaCRS needs to access certain web services, & the following domains need adding to the whitelist on your firewall/proxy server in order to prevent system failures: 

1. https://nww.ibid.mdsas.nhs.uk - the current base URL for the National Database - please note the use of SSL.
2. www.EvolutionHealthcareSystems.co.uk - for bug reporting, help files and helpdesk systems.
3. www.ibidb.org - this is the information website for the iBID database, & is where software is made available and service reports are obtained.

Failure to allow these websites through firewalls and proxy servers can adversely affect the performance and data commissioning abilities of the software

Retrieved from ‘https://evolutionhealthcaresystems.co.uk/help/index.php?title=Database_and_Server_Set_Up&oldid=5558’