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 is port 8099) by adding a line Port=8098 to the [Settings] section.
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).