I've gone ahead and configured the Report Server after SQL Server installation, and as part of that I've ended up with:
1) a report server database and
2) a link (I think in 2016 they call it Web Portal), where reports are to be deployed I guess.
I realized this was incorrect, I should not have configured/installed Report Server to begin with. I need to remove REPORT SERVER without removing Reporting Services. To be specific, I need the link (the Web Portal, or the link Report Server puts up) REMOVED and the Report Server database removed also.
The ONLY instructions I get are for removing Reporting Services, here and here , all that's talked about is removing Reporting Services. I just need the Report SERVER (DBs) and Report Server LINK to be removed. How do I accomplish that?
I'm using SQL Server 2016. Thank you very much in advance.
Best Answer
To take the Reporting Services databases out of commission on this server without disrupting the service itself, you'll need to point the service to databases elsewhere. To do this, open Reporting Services Configuration Manager on the server running the RS service, and change the "Database Name" entry in the Database menu page:
To shut down the Report Manager web portal, open up the RSReportServer.config file. This is located in the install directory (usually C:\Program Files\Microsoft SQL Server\[Instance Name]\Reporting Services\ReportServer).
Under the
<Service>element, there will be several elements that begin with "Is". These control which services/functions are enabled. The last entry will be<IsReportManagerEnabled>.Change this value from True to False. Save the file and close.
Some changes to RSReportServer.config require a service restart, so you may have to restart the RS service to get this change to stick. Once it does, the RS service will no longer respond to requests to the Report Manager portal but the separate web service that processes report requests will continue running.
You can read more about RSReportServer.config and switching individual services on/off here: https://msdn.microsoft.com/en-us/library/ms157273.aspx#bkmk_service