Select the product you need help with

SQL Server 2005 Reporting Services does not save dump files to the location that you specify in the Dr. Watson for Windows tool

Article ID: 913046 - View products that this article applies to.

Bug #: 20011181 (SQLBUDT)

SYMPTOMS

Consider the following scenario. You want to set a dump file location for Microsoft SQL Server 2005 Reporting Services. To do this, you specify a location for the Crash Dump option in the Dr. Watson for Windows program error debugger tool. In this scenario, SQL Server 2005 Reporting Services continues to save the dump file to its own log files location. SQL Server 2005 Reporting Services does not save the dump files to the location that you specify in the Dr. Watson for Windows tool.

Note The Dr. Watson for Windows tool is included with Microsoft Windows.

Back to the top | Give Feedback

CAUSE

This issue occurs because SQL Server 2005 Report Services generates a dump file to the following location by default:

Drive:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

Notes

Drive represents the drive on which SQL Server 2005 Reporting Services is installed.
MSSQL.x represents the corresponding instance ID for the system. To determine the instance ID for the system, follow these steps:
1. Connect to the instance of the SQL Server Reporting Services service by using the Reporting Services Configuration tool.
2. Click Server Status to open the Report Server Status page.
3. On the Report Server Status page, note the instance ID information.

Back to the top | Give Feedback

WORKAROUND

Warning Serious problems might occur if you modify the configuration files incorrectly. Make sure that you have a copy of the configuration files before you modify them.

To work around this issue, specify the new location for the dump file in the configuration files for SQL Server 2005 Reporting Services. To do this, follow these steps:

In Notepad, open the ReportingServicesService.exe.config file that is located in the following folder:
Drive:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\Bin
Add the following code to the <RStrace> section:
<add name="FileName" value="ReportServer_" /> <add name="Directory" value="YourPath" />
Note YourPath represents the folder in which you want SQL Server 2005 Reporting Services to save dump files.
In Notepad, open the Web.config file that is located in the following folder:
Drive:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer
Add the code that is listed in step 2 to the Web.config file.
In Notepad, open the Web.config file that is located in the following folder:
Drive:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportManager
Add the code that is listed in step 2 to the Web.config file.

Note Changing the directory location for the dump files also changes the location for the SQL Server Reporting Services log files. You will need to set permissions on the new folder to match the permissions on the LogFiles folder.

Back to the top | Give Feedback