PIM: blank set in generated password by Password Policy

Document ID : KB000125494
Last Modified Date : 30/01/2019
Show Technical Document Details
Question:
When user login with SAM automatic login to MS SQLStudio, it failed.
He researched problem and found it cause with blank in password. Hu0.: N (blank before N.)
Why does it generate with blank?
please let him know how to configure without blank.
sample Password Policy is here:
Minimum password length:7
Maximum password length:7
Maximum repeating characters:0
  Upper case letters (u for pattern) Allow, Minimum 1
  Lower case letters (c for pattern) Allow, Minimum 1
  Letters (l for pattern) Allow, Minimum 1
  Digits (d for pattern) Allow, Minimum 1
  Letters or digits (a for pattern) Allow, Minimum 0
  Punctuation (p for pattern) Allow, Minimum 0
  Any (* for pattern)
  Use Pattern: check-off
  Prohibited characters: N/A
Environment:
OS: Windows 2012 R2
Prod: CA Privileged Identity Manager r12.9 SP2 for SAM + some fix
  CDB: MS SQLServer 2014
  User store: ActiveDirectory
SAM Endpoint: SQLServer
 
Answer:
1. When user select 'Any'  in password rule, it may occur 'space' in password. It is design for this product.
2. please set 'space' in Prohibited characters.