# 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

**URL:** <https://discuss.workflowgen.com/t/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/613>\
**Category:** Authentication\
**Created:** [March 23, 2010, 6:10am UTC](https://discuss.workflowgen.com/t/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/613 "2010-03-23T06:10:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wfg-admin](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/wfg-admin/32/714_2.png) [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\
**Post date:** [March 23, 2010, 6:10am UTC](https://discuss.workflowgen.com/t/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/613/1 "2010-03-23T06:10:00Z")

</div>

### Issue

User receives the following User Portal security access error 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.

```auto
SQL> alter session set NLS_COMP = ANSI;

```

```auto
SQL> alter session set NLS_SORT = BINARY_AI;

```

#### SQL Server

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

#### Environment variables

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

`NLS_SORT=BINARY_CI`

`NLS_COMP=LINGUISTIC`

Once completed, restart IIS. Then, open a command prompt and enter:

`iisreset /noforce`