Difference between revisions of "Database and Server Set Up"

From EHS Help
Jump to: navigation, search
(Rewrite for clarity)
Line 11: Line 11:
 
==Step 1. Database Installation==
 
==Step 1. Database Installation==
  
−
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.
+
#Create an empty SQL Server Database
 +
#Create a new login for that database that the app-server can use to access the 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.
 +
#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.
  
−
Create an empty SQL Server Database and ensure that there is a specific login for that database that the server can use to access the database.  For installation of the application server you will need to know the server name of your SQL server, database name, user name and password.
+
For the installation of the app-server later you will need to know the server name of your SQL server, database name, user name & password you just created.
−
 
+
−
Using your tool of choice (usually MS SQL Server Management Studio) run the downloaded SQL script against the empty database to create the tables, views and to pre-populate the data.
+
  
 
==Step 2. Application Server Installation==
 
==Step 2. Application Server Installation==
Line 22: Line 23:
  
 
#Unzip the AquilaServer_setup file
 
#Unzip the AquilaServer_setup file
−
#Run the installer wizard.
+
#Run the installation wizard.
 
#Edit the '''Connection String''' parameter during the installation.  Replace the items in italics with your own settings
 
#Edit the '''Connection String''' parameter during the installation.  Replace the items in italics with your own settings
 
## AnyDAC?AuxDriver=MSSQL;Server=''SERVERNAME'';Database=''DATABASENAME'';UserID=''USERID'';Password=''PASSWORD'';
 
## AnyDAC?AuxDriver=MSSQL;Server=''SERVERNAME'';Database=''DATABASENAME'';UserID=''USERID'';Password=''PASSWORD'';
 
#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.
+
##The settings filename is aquilaserver.ini if you need to make any changes - restart the 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.
 
#Check ''services.msc'' to ensure that the AquilaServer service has been started and is set to Automatic.
  
−
===Client Application Server URL===
+
====Server URL====
  
−
The Server URL is needed by all users of the IBID application on their first login, and is made up as follows:
+
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:
  
 
http://'''SERVERNAME''':'''PORTNUMBER'''/bin.
 
http://'''SERVERNAME''':'''PORTNUMBER'''/bin.
  
−
If the application server is installed on a server called TRUSTSRV01 and is listening on the default port, 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'''
  
 
==Step 4: IBID Software Installation==
 
==Step 4: IBID Software Installation==
  
−
#Download the '''IBID User Application Setup''' from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' section.
+
#Download the '''IBID User Application Setup''' from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' section. 
 +
##Use either '''per-user''' or '''all-users''' -see [AquilaCRS Enterprise Installation Overview] for information on each type.
 
#Run the installation program and enter the Server URL when prompted.
 
#Run the installation program and enter the Server URL when prompted.
−
#Run the client application and log on with the username '''admin''' and the password '''adminabc123''' (case sensitive) and the enter the ''Server URL'' previously mentioned by clicking on the 'Connection' link on the login form.
+
##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]]
 +
 +
''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.''
  
 
==Step 5: First time setup of IBID==
 
==Step 5: First time setup of IBID==
 +
 +
Designated system administrators at each site will receive an initial administrator level login separately.
  
 
#Go to the '''IBID Installation and Setup''' page.
 
#Go to the '''IBID Installation and Setup''' page.
Line 51: Line 58:
 
##Enter your IBID Unit ID and click Register.  This will open IBID features in the software and also test connectivity to the National Database.
 
##Enter your IBID Unit ID and click Register.  This will open IBID features in the software and also test connectivity to the National Database.
  
−
==Step 6: BIBID Import (optional: For existing BIBID software users only)==
+
System administrators can now create additional ''standard'' users. It is highly recommended that the system administrator creates another administrator level user for themselves.
−
 
+
−
If you have not previously used the BIBID software to record burn injury data then you can skip this section and continue to '''Step 6: User Access'''.
+
−
 
+
−
{{template:BIBID Import}}
+
−
 
+
−
==Step 7: User Access==
+
−
 
+
−
When the BIBID data transfer has completed successfully, you can allow users to access the database. Use the "User Management" tab to create user profiles.  You may create other Administrator users to manage user profiles.
+
−
 
+
−
===Step 8: User App Installation===
+
−
 
+
−
The client application is installed ''per-user'', so each user needs to install their own copy of the client software, which is vital to allow the ability to receive automatic program updates.
+
−
 
+
−
''Citrix users'' - there is an "all users" version of the installation that installs to the ''Program Files'' folder. However, the app will not be able to automatically update, so you will have to run the upgrade setup program manually on each release, or manually replace the files.  We estimate release schedules to be no more than bi=monthly.
+
  
−
#Download the '''IBID User Application Setup''' from [http://www.ibidb.org/ibid www.ibidb.org/ibid]
+
===Step 6: Desktop software installation & users===
−
#Unzip and run the aquila_setuip installation program.
+
−
#Enter your own Server URL in the field when prompted.  Takes the format '''http://''servername'':8099/bin'''
+
−
#Double click the ''Aquila CRS'' icon on your desktop to run the application
+
−
#Enter the username and password assigned by your system admin
+
−
#Click the Connection link and enter the '''Server URL''' previously mentioned (you only need do this once).
+
  
−
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.
+
Repeat step 4 to install the iBID software wherever you need it.   
  
 
To discuss any aspect of the installation please raise a ticket on our [http://www.evohelpdesk.co.uk helpdesk] system, or call 01964 503400.
 
To discuss any aspect of the installation please raise a ticket on our [http://www.evohelpdesk.co.uk helpdesk] system, or call 01964 503400.

Revision as of 10:08, 19 February 2014

This is a Technical (IT) Instructions topic


Target Audience

These instructions are of a technical nature & intended for trust level IT staff & requires experience of:

  • MS SQL Server - creating databases and running scripts,
  • TCP/IP - Installation and configuration of windows services, TCP/IP ports and firewall configuration

Step 1. Database Installation

  1. Create an empty SQL Server Database
  2. Create a new login for that database that the app-server can use to access the database.
  3. Download the IBID Server MSSQL Script zip file from www.ibidb.org in the IBID Software Downloads section. 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 the data.

For the installation of the app-server later you will need to know the server name of your SQL server, database name, user name & password you just created.

Step 2. Application Server Installation

Download the IBID Server Application Setup from www.ibidb.org in the IBID Software Downloads section.

  1. Unzip the AquilaServer_setup file
  2. Run the installation wizard.
  3. Edit the Connection String parameter during the installation. Replace the items in italics with your own settings
    1. AnyDAC?AuxDriver=MSSQL;Server=SERVERNAME;Database=DATABASENAME;UserID=USERID;Password=PASSWORD;
  4. Continue the installation wizard until complete.
  5. 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 - restart the service once changes have been made to this file.
  6. 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:

http://SERVERNAME:PORTNUMBER/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

Step 4: IBID Software Installation

  1. Download the IBID User Application Setup from www.ibidb.org in the IBID Software Downloads section.
    1. Use either per-user or all-users -see [AquilaCRS Enterprise Installation Overview] for information on each type.
  2. Run the installation program and enter the Server URL when prompted.
    1. The Server URL is also available on the login screen by clicking the Connection link

Ibid admin login.png

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.

Step 5: 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.

Step 6: Desktop software installation & users

Repeat step 4 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.

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