Environment Information- Tested on CP 6.3.x and 6.4.x.
I am getting the below error when I try to configure the authentication source.
"Primary: Login Username contains special characters other than -, _ and ."
Cause- Connecting to MSSQL DB using integrated authentication needs the login username with domain prefix or userPrincipleName(UPN). But the currently available ClearPass versions will not allow you to enter any special characters other than "-,_ and ." in the login username filed when you add the MSSQL DB.
Resolution- The SQL authentication source username validator in ClearPass 6.5.0 release is adjusted to accept the domain prefix with the login username field. So that the MSSQL DB enabled with integration authentication can be configured as authentication source from ClearPass 6.5.x.
Answer- The domain prefix can be added in the format DOMAIN\\Username.
Note: Only username with domain prefix is allowed and userPrincipleName(UPN) format is not support.
Please refer the below screen capture for configuration assistance.