Problem Description
Users experience UI discrepancies when assigning credentials to SQL Server resources.
The system displays an error message indicating credential assignment failure at the UI level, however, the credentials are actually assigned successfully.
This becomes apparent when the UI is refreshed, showing the credentials have been properly assigned despite the initial error message.
Cause
The error occurs when SQL Server credentials contain specific special characters that interfere with the encoding/decoding process or string literal generation. The problematic characters include:
Forward slash (/)
Comma (,)
Single quote (')
Double quote (")
Traceback
Windows has inherent limitations with special characters in certain authentication flows.
Druva does not impose restrictions on password characters.
The underlying error originates from Microsoft's logonUserW.Call functionality.
Druva products consume Microsoft-provided SDKs for authentication purposes.
โError in Assigning Credentials. Error :Error while assigning credentials to device:<device_id>, fault: Operation failed (#1000000bb) (Error Code : PHOENIX187)
Resolution
Immediate Solution
Create new credentials with a password that excludes the following characters:
Forward slash (/)
Comma (,)
Single quote (')
Double quote (")
Remove existing problematic credentials from the SQL Server resource.
Assign the new credentials to the SQL Server resource.
Verify assignment by refreshing the UI to confirm successful credential assignment.
Password Best Practices
Follow Microsoft's official SQL Server password policy guidelines:
Use strong passwords with a mix of uppercase, lowercase, numbers, and symbols.
Avoid the problematic special characters mentioned above.
Ensure password meets your organization's security requirements.
Verification
Credential Creation: Always avoid using /, , ', " characters when creating SQL Server service account passwords.
Password Policy: Implement organizational password policies that exclude these problematic characters for SQL Server accounts.
Documentation: Ensure IT teams are aware of these character limitations when creating SQL Server service accounts.
Reference: Microsoft SQL Server Password Policy Guide