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
Resolution
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.