Using PowerShell to modify RSReportServer.config

Question

How do one use PowerShell to update or change the RSReportServer.config file?

I want to change the value in the IsReportManagerEnabled tag, inside the Service tag, from True to False.

Thanks a lot.

Answer 1

Per http://msdn.microsoft.com/en-us/library/bb630448.aspx , your config file is most likely in c:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\ but update the below to be correct for your system. And make a backup of the file before doing anything else.

[xml]$config = gc "c:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\RSReportServer.config"
$config.SelectSingleNode("//IsReportManagerEnabled").InnerText = "False";
$config.save("c:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\RSReportServer.config")

You may need to restart the ReportServer service for this to take effect.