User receives a security access error to the portal when the Windows login name does not match the casing of the username in WorkflowGen database


#1

Issue

User receives the following security access error to the portal when the Windows login name does not match the casing of the username in WorkflowGen database:

.Net SqlClient Data Provider: Invalid column name ‘RES’

Reason

The database is configured to be case sensitive which is not supported by WorkflowGen.

Solution 

Oracle:

The NLS_COMP and NLS_SORT variables must be changed to support case insensitive.

SQL> alter session set NLS_COMP = ANSI;

SQL> alter session set NLS_SORT = BINARY_AI;

SQL Server:

The database instance’s collation must be changed to support case insensitive.

Environment variables:

Furthermore, the following environment variables should be added to the web server:

NLS_SORT=BINARY_CI

NLS_COMP=LINGUISTIC

Once completed, restart IIS. From the command prompt type: iisreset /noforce