In the <policyserver_home>/db/SQL, sample user schemas are provided, such a file as 'smsampleusers_sqlserver.sql'. This article explains an important restriction on SmUser and SmGroup Schema.
Policy Server: all version
The column 'Name' is present in both SmUser and SmGroup tables (as shown below) and it is mandatory to have this column common in both the tables. If you create your own user and group tables, you must follow this.
CREATE TABLE SmGroup (
GroupID int NOT NULL,
Name SmStringReqN,
PRIMARY KEY (GroupID)
)
CREATE TABLE SmUser (
UserID int NOT NULL,
Name SmStringReqN,
Password SmStringReqN,
LastName SmStringReqN,
FirstName SmStringReqN,
EmailAddress SmStringReqN,
TelephoneNumber SmStringReqN,
Disabled SmStringReqN,
PIN SmStringReqN,
Mileage int NOT NULL,
PasswordData varchar(2000) NOT NULL,
PRIMARY KEY (UserID)
)