Cause
This error occurs if your SQL Server database Setting of "Collation" is configured to be "case sensitive", hence, when the versaSRS HelpDesk Database Creation Script is attempting to create the required Database View - the required column name can not found and therefore the View is not created.
IMPORTANT NOTE >> As a further result of above - due to the installer error roll-back function - proper installation of the versaSRS HelpDesk Database has not been successfully performed!
Resolution
Manual update of the supplied Create Database Structure script is required - this will then allow creation of the database with the SQL Server Collation Property set to "case insensitive".
To do so, please modify the script file "versaSRS_v4_0_0_struct.sql" using notepad or similar, taking care not to change the file extension. For a default installation this file is typically located at;
C:\Program Files\VersaDev\VersaSRS\Setup\SQLScripts\versaSRS_v4_0_0_struct.sql
Replace the line
CREATE DATABASE [<VERSASRS_DBNAME>]
with
CREATE DATABASE [<VERSASRS_DBNAME>] COLLATE Latin1_General_CI_AI
After the change above has been made - re-run the SMC and go through the New Installation Process as described in the Installation Manual.