Can I run V6 and V7 on the same server?

Problem

Client is currently on 6.5.13 and wants to test version 7 before going live.  Can both versions be run on the same SQL Server?

Solution

SQL skills are required

SQL skills and access to SQL Management Studio are required to perform this task

Both versions can be run on the same machine and both versions of the database can be located on the same server provided SQL 2012 or higher is running (requirement for V7).  Because of enhancement security requirements for the SQL users in V7, the SQL user passwords for the version 6 database needs to be changed.  

The attached script is to be run over the V6 database.  Run the script in the stages identified in the script to ensure all sections are successful.

If you are running both versions of Jiwa on Windows 8 or higher in 64 Bit mode you may need to copy the attached login DLL into the Jiwa 6 program directory (no need to register the DLL)