Core Issue
Database replication from Publisher to Subscriber does not occur. This could be because the password for the Structured Query Language (SQL) CiscoCCMCDR user is incorrect.
Resolution
Resetting the CiscoCCMCDR user password to dipsy resolves the issue. Refer to the CDR Database Access section of Administrative Tools Overview.
To reset the CiscoCCMCDR user password, perform these steps:
- Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.
- Go to Microsoft SQL Servers > SQL Server Group.
- Double-click the machine name (the Domain Name System (DNS) name of the machine).
- Go to Security > Logins.
- Right click on CiscoCCMCDR.
- Go to Properties. Select the General tab, and change the password to dipsy.