Posts Tagged ‘Systems’

Changing the location of log files for SQL Server Reporting Services

I have found a few occasions where I have needed to change the location of my Reporting Services Logfiles and wanted to share it with you.

There are three files you need to modify to change the location of the Reporting Services Logfiles. These files are:

· c:\Program Files\Microsoft SQL Server\Reporting Services\ReportManager\web.config

· c:\Program Files\Microsoft SQL Server\Reporting Services\ReportServer\web.config

· c:\Program Files\Microsoft SQL Server\Reporting Services\ReportServer\Bin\ReportingServicesService.exe.config

Add the following tag under RSTrace in all the above files:

<add name="Directory" value="c:\directorypath" />

Be sure that you apply the same permissions to the new path folder that is on the LogFiles folder.

Restart the ReportServer Windows Service

Click on Start, Control Panel, Administrative Tools, Services and look for Reporting Services Service. Double Click on the service, Click “Stop” and then “Start” to restart the service.

From SQL Blog

Categories: SQL Server Tags: , ,