DescriptionThis article describes how to resolve the issue of LDAP users can not login EMS and also can not create any new LDAP users in EMS.Getting the error “'42S22', "[42S22] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'None'.
Usefull link:
External
Subnet calculator – http://www.subcalc.com/
Solution1) Download Microsoft SQL Server Management Studio and install it on EMS server
2) Login MSSM
Go to FCM_root -> Tables
Right click on "dbo.admin_user" and choose “Edit Top 200 Rows”
3) Right click the problematic user and delete it from this table then it will be possible to create new accounts in EMS