New installs using localdb instance of demo data may error with "Invalid column name HR_Staff.ActiveLogIn" when logging in.

If there is no JiwaConnections.xml in the folder %appdata%\Roaming\Jiwa Financials and there is also no JiwaConnectionsTemplate.xml in the Jiwa installation folder, the system will attempt to create a new demo database using localDb and setup a new JiwaConnections.xml with a connection named "JiwaDemo" pointing to that database.

However, after copying the JiwaDemo_Primary.mdf to the localDb folder location, a subsequent step of setting permissions is incorrectly using the 'grant_all_user_tables' stored procedure which causes an exception, resulting in no connection being created and the database not having the required permissions set.

If the user then manually creates a connection to the demo database on (localdb)\mssqllocaldb, the error "Invalid column name HR_Staff.ActiveLogIn" will occur because the initial read of HR_staff fails due to no permissions, so we then try to connect using the old structure of HR_Staff in an attempt to obtain the version number of the database in preparation of what would be a more meaningful error.

Workaround is after manually creating the connection in this scenario to run the following against the database:

usp_Jiwa_Grant_Application_Permissions 'JiwaUser'
GO

usp_Jiwa_Grant_Reporting_Permissions 'JiwaReports'
GO