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

Document created by RSA Customer Support Employee on Sep 26, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034079
Applies ToRSA Product Set: NetWitness Endpoint, ECAT
RSA Product/Service Type: ECAT UI
RSA Version/Condition:,
Platform: Windows
IssueDuring 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.
CauseIt 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.
ResolutionThere 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.
  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.
 select user

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

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

  1. Highlight User mappings and select the ECAT$Primary database. Under Database Role membership, select db_owner and public.
  2. 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)

Final permissions displayed