Installing iBID Central Database

This is a Technical Instructions topic

The Database

Following to be performed using MS SQL Server Management Studio (or equivalent tool).

1. Download the aquila_mssql_ddl zip file and unzip the 3 scripts
2. Create a new MSSQL database on your MSSQL server instance.
3. Run each of the 3 scripts against the new database to create the database objects
4. Create a new user for the application servers to access the database & grant all rights to all objects in the database.

The Web Server

1. Download the aquila_webserver.zip package.
2. Unzip both files (aquilaweb.exe and aquilaweb.ini) to the scripts folder of your IIS installation (cgi-bin)
3. Edit the ConnectionString property in the aquilaweb.ini file to specify the server, database, username and password previously set up.

Notes:

• The web server does not have to be on the same server as the MS SQL Server instance.
• Please supply us with the URL of the webserver including the path to the aquilaweb.exe web module, e.g. http://ibid.mdsas.com/cgi-bin/aquilaweb.exe as this forms part of the URL for sending centralised data returns.

The Local Application Server

1. Download the aquilaserver_setup.exe installation script & run on your chosen app server. (Can be different from the web & sql servers, or the same)
2. Edit the ConnectionString property in the file {program files}\Evolution Healthcare Systems Limited\AquilaServer\AquilaServer.ini to specify the server, database, username and password previously set up.
3. In the same file you can specify a different port for the app server to listen on (defaults to port 8099).
4. Ensure that your firewall has this port open, or create an exception rule for aquilaserver.exe.
5. Open Services.msc & ensure that the aquilaserver.exe is started and it set to start Automatically.

The Client Application

To test the installation, download the client application installation (aquilacrs_setup.exe) & install. The installation will ask you for the database URL, which is made up as follows:

http://SERVERNAME:PORT_NUMBER/bin

Replace SERVERNAME with the name of the server hosting AquilaServer.exe and replace PORT_NUMBER with the configured port number, e.g. http://myserver:8099/bin. You can also edit this setting at the Login screen.

Login credentials:

• Username: admin
• Password: adminabc123

(You will be prompted to change the password on logging in, please make a note of the new password).