If I do not choose Reporting Services SharePoint Integrated Mode while installing SQL Server and also I didn't installed Reporting services Add-in for SharePoint and in future I need to have SSRS in my SharePoint 2013 Farm then how would I be able to get SSRS working in SharePoint 2013? Is there a fix for it or do I need to reinstall SQL Server?


You have to run the setup not by removing the existing sql just to add additional features to existing installed sql

see the below post what features need to select to install SharePoint Reporting Services. https://whitepages.unlimitedviz.com/2012/07/setting-up-reporting-services-2012-with-sharepoint-2013/

You also see this port configure Reporting Services on SharePoint.


| improve this answer | |
  • Agree with adding features like "Reporting Services-SharePoint" and "Reporting Services Add-in for SharePoint Products" by re-running the setup but what about installing SQL in "Reporting Services SharePoint Integrated Mode"? Will I get this changed from Native to Integrated Mode by re-running the setup? – Zakir HC Mar 2 '17 at 6:04
  • 1
    The SSRS database cannot be converted between modes. In addition, the SSRS instance must be installed on a SharePoint server joined to the farm. – Trevor Seward Mar 2 '17 at 6:30
  • It won' change on the SQL default instance(MSSQL). You have to create a separate instance to host the reporting services. – Suresh Bolineni Mar 2 '17 at 7:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.