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.