| Table of Contents | ||
|---|---|---|
|
Prerequisites
Microsoft Windows 7 or later
Jiwa 7 supports the following operating systems:
- Windows 7
- Windows 8.1
- Windows Server 2008R2
- Windows Server 2012
- Windows Server 2012R2
Microsoft SQL Server 2008R2 Express or later
For evaluation purposes, you do not need to install an SQL Server. The installation will install MSSQL Localdb and create a connection to a demo database automatically. The limitation with localdb is that it is single user only - for multiple concurrent users, Jiwa 7 requires a connection to an SQL Server. You can install the SQL Server on the same machine as Jiwa 7, or any machine accessible via the network. Jiwa 7 also supports Microsoft Azure SQL servers. Jiwa 7 supports the following SQL Server versions:
- SQL Server LocalDB
- SQL Server 2008R2
- SQL Server 2012
- SQL Server 2012R2
- SQL Server 2014
- Azure SQL
NOTE: Jiwa uses SQL Server authentication, so when installing Microsoft SQL Server, chose mixed mode authentication when prompted during the installation process. This can also be changed post-installation.
Install Jiwa
Locate the setup.exe file from the directory where you stored it during the download. Right click on it and select “Run as administrator”. The installation dialog will open.
Read and Accept the License Terms and Conditions and select Install.
Jiwa will now run through the installation process. This may take several minutes.
At the conclusion of the installation you may be prompted to reboot to complete the installation. The Crystal Reports component Jiwa 7 uses for the reporting engine requires a reboot after installation - Jiwa 7 can still be used without this reboot step provided no reports are generated.
Create a Demonstration database
Double-click the Jiwa 7 shortcut on the desktop.
The login dialog will appear.
There will already be a connection and demo database created for you using the installed LocalDB database - if you do not need to evaluate Jiwa with multiple concurrent users then you need proceed no further - just enter the password "password" (without quotes) and then click the "connect" button and you will login to the locally installed database. You can then disregard the remainder of this guide. If you do wish to connect to an SQL server, then click on the "databases" button and then click Next to begin the wizard.
Select the "Create a new Jiwa demonstration database" option.
From the Server Dropdown select the MS SQL server where Jiwa 7 is installed, type in “sa” SQL Login enter “sa” and the relevant password you created in Step 1 and select Next.
Type in the name that you would like the database to use in MS SQL. Only use alpha-numeric characters and to not leave any blank spaces in the name. The Checkbox ‘Please automatically add the database to my connection list’ is ticked by default. This will create a Connection with the same name as the Database Name. The connection name can be changed to something else. Selecting the Reset all staff SQL logins and passwords checkbox allows the administrator to reset the SQL Passwords for the ‘JiwaUser’ and the ‘JiwaReports’ users. NOTE: This is optional. By default the passwords are set to the Jiwa Standard password
Jiwa will then give a summary of the database that it will create and select Finish.
Jiwa will now build the database and it may take a few minutes – be patient :)
When it is finished, select Close and you will be returned to the Connect to Jiwa screen with the Connection Name already selected for you.
Creating a Connection to a Database
If you unticked the “Please automatically add the database to my connection list’, when you created a database then you still can create a connection manually.
From the Login dialog select Connections.
On the Connection Wizard Welcome dialog select Next
Select Create a new Connection and select Next
Enter a Connection Name (this one can have spaces)
Select your MS SQL Server from the drop down or enter the server name manually. SQL Login and SQL Password are automatically populated with the jiwalogin user and the password jiwaapplicationlogin. Then use the drop down menu to select the database from those available on the SQL server and select Next
Jiwa will then give a summary of the connection that it will create. Check the details and if they are correct select Finish then Close.
Now that the connection has been added, Jiwa will return you to the Jiwa Login Dialog.