| Table of Contents | ||
|---|---|---|
|
Prerequisites
Microsoft Windows 7 or later
Jiwa 7 supports the following operating systems:
- Windows 8.1
- Windows 10
- Windows Server 2012
- Windows Server 2012R2
- Windows Server 2016
- Windows Server 2019
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 serversServers. Jiwa 7 supports the following SQL Server versions:
- SQL Server LocalDB
- SQL Server 2012
- SQL Server 2012R2
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- Azure SQL
NOTE: Jiwa uses SQL Server authentication, so when installing Microsoft SQL Server, chose choose 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.
Log in to Jiwa
The login to a Jiwa Demonstration database is admin and the password is password
Select Connect. You are now ready to use Jiwa.
Creating a Connection Template
When Jiwa is installed in a multi-user environment (such as Microsoft Remote Desktop Services), it can save much configuration time if all system users (and any users added in the future) are given a default set of connections from a common template.
When Jiwa is run it first looks for %appdata%\Jiwa Financials\JiwaConnections.xml. This is where the list of connections for the current user is stored. If Jiwa does not find this file, it then looks for a file called "JiwaConnectionsTemplate.xml" in it's installation folder. If this file is found, it is copied into %appdata%\Jiwa Financials\ as "JiwaConnections.xml". If it is not found, then a blank "JiwaConnections.xml" is created in %appdata%\Jiwa Financials\.
Those steps again:
- Look for a list of connections in %appdata%\Jiwa Financials\JiwaConnections.xml
- If no such file is found look for <Jiwa Installation Folder>\JiwaConnectionsTemplate.xml
- If JiwaConnectionsTemplate.xml exists, copy it to %appdata%\Jiwa Financials\JiwaConnections.xml
- If NO JiwaConnectionsTemplate.xml exists, create a blank %appdata%\Jiwa Financials\JiwaConnections.xml
So after installing Jiwa in a multi-user environment, a template of connections can be constructed. Run Jiwa and create/delete connections as required. Exit Jiwa. Copy the file at %appdata%\Jiwa Financials\JiwaConnections.xml to <Jiwa Installation Folder>\JiwaConnectionsTemplate.xml.
Now, any user that runs Jiwa that does not already have their own set of connections will be given a copy of the template of connections as a base for their own connection list.
Using Jiwa
The Jiwa menu is displayed in the left hand navigation pane. It can be collapsed by clicking the ‘Minimize Navigation panel’ button from the navigation pane header. This provides more screen visibility for the actual form you are in. The details to using Jiwa can be found by clicking on the Help button on each open form.
Troubleshooting
Password Policy
Sometimes, Jiwa demo might have problem installing due to the password policy in MS SQL. To correct this, you need to use MS SQL Management Studio. Run MS SQL Management Studio, connect to the SQL Server, and then expand Security > Logins. Of interest are the JiwaLogin, JiwaReports and JiwaUser logins.
Right click on JiwaLogin and select Properties.
On the Login Properties screen, remove the tick from the Enforce Password Policy tick box and OK.
Repeat for JiwaUser and JiwaReports.
Changing Authentication Mode
You can change the Authentication mode through SQL Server Management Studio, the MS SQL Server Database Engine is set to either ’Windows Authentication mode’ or ‘SQL Server and Windows Authentication mode’. After installation, you can change the authentication mode at any time.
If ‘Windows Authentication mode’ is selected during installation, the ‘sa’ login is disabled and a password is assigned by setup. If you later change authentication mode to ‘SQL Server and Windows Authentication mode’, the ‘sa’ login remains disabled. To use the ‘sa’ login, use the ALTER LOGIN statement to enable the ‘sa’ login and assign a new password. The ‘sa’ login can only connect to the server by using SQL Server Authentication.
Change security authentication mode
In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.
Enable the sa login
In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties. On the General page, you might have to create and confirm a password for the login.
On the Status page, in the Login section, click Enabled, and then click OK.
Cannot Connect to the SQL Server
If you are having problems connecting to the SQL Server, you can begin the troubleshooting process by following the SQL Server Connectivity troubleshooting guide given here.