rsErrorImpersonatingUser

Cannot impersonate user for data source ‘CDRDB’. (rsErrorImpersonatingUser) error

rsErrorImpersonatingUser

While Configuring Lync Server: You get the above error when you click on reports or configure reports.

So what do you do ?

Solution:

Start by checking the following items:

1. SQL permissions for the user being used for reporting purpose.
2. AD Groups membership of the User
3. Permission on SSRS for the User
4. Permission on LYNC reports
5. Check Web applications on IIS (if windows auth is enabled)

Finally check if the account had a valid connection from SSRS to DB.

Perform the below steps:

• Open Reporting Services Configuration Manager
• Click on Report Manager URL
• Click Report URL (This will launch IE which I hope if your default browser)
• Drill into
• LyncServerReports
• Reports_Content

Update the username and password: for the Lync report database.(do the same for both the database) as shown below: