Problem
On selecting Setup > Synchronize Directory Services in Cisco Desktop Administration getting an error:
"At least one error occurred during the synchronization process"
or
In logs getting the below error:
2010-11-07 22:16:39:647 ERROR SYNC2018 Failed to synchronize LCC:<Call Center 1>, fcn<SPeripheral::initialize>, problem<sql failure, failed to
set peripheral id<5000>>, errcode<-20>.
Solution
The cause of this error is the SQL 'sa' account is locked, so to unlock the account run the following command:-
ALTER LOGIN sa WITH PASSWORD = 'new_password' UNLOCK
*Enter the existing ‘sa’ password if remembered, otherwise enter a new one.
