SSRS Data Source disabled in SharePoint 2013

ssrs data source disabled in sharepoint

Error:
After installing SP1 patching SharePoint 2013 SSRS reports are stop working. When I try to render SSRS report in SharePoint I got the below error.

ssrs data source disabled in sharepoint
ssrs data source disabled in sharepoint

Solution:
After installing SP1 SharePoint also made some changes in SSRS service. Which made all the data sources disabled.
Please follow the below steps to enable the Data Source
1. Ensure that “Report Server Integration” feature is activate as part of site collection features

SSRS Data Source disabled in SharePoint 2013
SSRS Data Source disabled in SharePoint 2013



2. Navigate to Data source library and open associated data source
3. Ensure that you selected right “Data Source Type”
4. Validate the connection string and credentials
5. Check the “Enable this data source” check box to fix this issue

ssrs data source sharepoint list
ssrs data source sharepoint list

6. As soon I change the check box checked SSRS reported started rendering

ssrs data source connection string
ssrs data source connection string

Hope this helps happy reporting in SharePoint 2013 !!!


You May Also like the Following SharePoint Online Tutorials:

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 12 years, I worked in SharePoint 2007, 2010, 2013, 2016 and Office 365. I have extensive hands on experience in customizing SharePoint sites from end to end. Expertise in SharePoint migration tools like Sharegate, Doc Ave and Metalogix. Migrated SharePoint sites from SharePoint 2007 to 2010 and 2010 to 2013 several times seamlessly. Implementing CSOM with Microsoft best practices. Spent quality time in configuring SharePoint application services like User Profile, Search, Managed Meta data services etc. Now exploring SharePoint Framework and SharePoint 2019

View all posts by Krishna Vandanapu →