Search code examples
powershellconfigreportserver

Using PowerShell to modify RSReportServer.config

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.

Solution

  • 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.