web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Reporting Service Issue
Microsoft Dynamics CRM (Archived)

Reporting Service Issue

(0) ShareShare
ReportReport
Posted on by Nidhi Mehta 24

Hi All,

As i am facing issue while running CRM reports from SSRS tool. Main issue is that we are unable to fetch data from database to reporting server.

As we have checked are all connections plus our services are also up.

Then we tried to reset our Encryption key but we are facing following error as we do not have the password while restore the report.

pastedimage1562328223232v1.png

Please help me on this issue. :)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at

    Hello,

    Is this error are faced in the SSRS Configuration Manager. Generally I delete the encryption key and try again.

  • Nidhi Mehta Profile Picture
    Nidhi Mehta 24 on at

    Hi,

    Yes, this issue is coming in SSRS, also we cannot delete the encryption key as we do not have backups of our reports.

  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    The SSRS encryption key is used to encrypt credentials and connection string data, but not report definitions. Deleting the encryption key will not affect your reports.

    You could also take a backup copy of the ReportServer SQL database before you delete the key, as this will contain all report definitions

  • Nidhi Mehta Profile Picture
    Nidhi Mehta 24 on at

    True, but while taking the backup need to enter password and we do not have that. So taking backup of reports is not possible.

    Is there any easy way to take a backup of reports?

  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at

    You can enter any password here, because you are taking a backup of the SSRS configuration.

    The password can be used later if you want to restore these backed-up configuration.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans