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.
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.
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.
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.
If the account is not listed, add the new login,
Verify the default database is set to master, shown above. Highlight Server roles and check public:
Highlight User mappings and select the ECAT$Primary database. Under Database Role membership, select db_owner and public.
Select the role that you wish to grant to the new user.
The options are ECAT_ROLE_Admin, ECAT_ROLE_L1Analyst, ECAT_ROLE_L2Analyst, ECAT_ROLEReadonly