DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 913046 - Last Review: February 14, 2006 - Revision: 3.2

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.

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.

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:
  1. 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
  2. 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.
  3. 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
  4. Add the code that is listed in step 2 to the Web.config file.
  5. 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
  6. 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.

MORE INFORMATION

To view the Help files for the Dr. Watson for Windows tool, follow these steps:
  1. Click Start, click Run, type drwtsn32.exe, and then click OK. The Dr.Watson for Windows tool opens.
  2. Click Help.

APPLIES TO
  • Microsoft SQL Server 2005 Reporting Services
Keywords: 
kbsql2005rs kbprb KB913046
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support