Unable to add Windows users to the UI in RSA NetWitness Endpoint

[#1]

Article Number

000034079

Applies To

RSA Product Set: NetWitness Endpoint, ECAT
RSA Product/Service Type: ECAT UI
RSA Version/Condition: 4.2.0.0, 4.1.2.0
Platform: Windows

Issue

During an attempt to add a Windows User as a registered user in the ECAT UI (as opposed to a SQL User) an error is seen in the window with the following description:

Windows User Creation Error

Incorrect Syntax Near '\'.

Note this is only an example error; for instance, if the name was WIN-MAPPED\John, the error would say Incorrect Syntax Near '-' so it is not limited to the backslash character but any unrecognized character used when attempting to add a new user.

Cause

It is unknown what the exact cause of the error is when attempting to read the user defined field for Windows users and is still under investigation.

Resolution

There are two ways to resolve this error message; one is to only add users as SQL Users in the UI, which will get around this issue but may not be feasible in every instance. The other is to follow the steps in the below workaround.

Workaround

1. Logon to the database instance and look under Security -> Logins for end user or add a new one. Technically, this is best done using the UI, as despite the fact the error says it has an invalid character, the user will be populated anyways.

 Image description

 

2. If the account is not listed, add the new login,

Image description

3. Verify the default database is set to master, shown above. Highlight Server roles and check public:

Image description

 

4. Highlight User mappings and select the ECAT$Primary database. Under Database Role membership, select db_owner and public.
5. Select the role that you wish to  grant to the new user.
   1. The options are ECAT_ROLE_Admin, ECAT_ROLE_L1Analyst, ECAT_ROLE_L2Analyst, ECAT_ROLEReadonly

(Details on what each role is in the User Guide)

Image description