Frequently asked questions about the SQL Server 2000 Reporting Services Data Gathering and Diagnosis tool (SRSDiag) (897127)

MORE INFORMATION

Q1: What is the SRSDiag tool?

A1: The SRSDiag tool is a command-line tool that helps a user do the following:

• Gather SQL Server 2000 Reporting Services troubleshooting-related information from the local computer.
• Analyze the gathered data and then diagnose the problem. The tool can do this if the problem is captured in the rules information repository of the tool.

Q2: Are there any prerequisites?

A2: Yes, you must install the following two prerequisites:

• The Microsoft .NET Framework 1.1
• SQL Server 2000 Reporting Services

Q3: How do I install the SRSDiag tool?

A3: Download the SRSDiagnosticsTool.exe file. When you run the file, extract the compressed files to a local folder on the computer that is running SQL Server 2000 Reporting Services.

Q4: What files are included in the SRSDiagnosticsTool.exe file?

A4: The SRSDiagnosticsTool.exe file contains the following files:

  Date         Time   Version         Size    File name         Description
  ------------------------------------------------------------------------------------------
  02-Mar-2005  22:25  1.0.1887.31353  40,960  SRSDiag.exe       SRSDiag Executable
  18-Nov-2004  17:02                   4,567  Rules.xml         Rules information repository
  08-Sep-2004  02:02                   1,628  Rules_schema.xsd  Schema for the rules

Q5: What does the SRSDiag tool do?

A5: The SRSDiag tool runs in the following two modes

• Data gathering mode
  In this mode, the SRSDiag tool gathers data from the following sources:
  • Report Server and Report Manager configuration files
  • SQL Server 2000 Reporting Services Setup files
  • SQL Server 2000 Reporting Services log files
  • SQL Server 2000 Reporting Services registry data
  • Microsoft Internet Information Services (IIS) Metadata
  • IIS error logs
  • Event logs
  • Local computer network information
  All this data is stored in a new time-stamped subfolder in the folder where SRSDiag is run. Additionally, a time-stamped log file is created in the same subfolder. This log file records the success or failures of the data gathering.
  
  Note The time that is required to gather data is largely proportional to the size of the Event logs and of the IIS error logs. Therefore, if the log files are very large, we recommend that you clean up unwanted and old Event log entries and IIS Error logs before you run the SRSDiag tool.
• Analysis and diagnosis mode
  In this mode, the SRSDiag tool scans and analyzes the SQL Server 2000 Reporting Services data that is gathered. Then, the tool compares this data to problem scenarios that are recorded as rules in the rules information repository. The diagnosis output is persisted into a new subfolder that was created in the data-gathering folder.

Q6: How do I run the SRSDiag tool?

A6: Follow these steps:

1. At a command prompt, locate the folder where you extracted the SRSDiagnosticsTool.exe files.
2. Use the following syntax to run the SRSDiag tool:

   SRSDiag [ -G [ConnectionString] | -A RulesSchema RulesFile SRSDiagFolder | -?]

   Note The SRSDiag tool uses the following parameters:
   • -G
     Run SQL Server 2000 Reporting Services data gathering mode.
   • ConnectionString
     Replace ConnectionString with the SQL Server Microsoft .NET Framework Provider connection string to connect to the ReportServer database. This parameter is optional.
   • -A
     Run SQL Server 2000 Reporting Services data analysis and diagnosis mode.
   • RulesSchema
     Replace RulesSchema with the path and the file name of the rules schema file.
   • RulesFile
     Replace RulesFile with the path and the file name of the rules XML file.
   • SRSDiagFolder
     The data that was gathered by using the SRSDiag -G command was saved to a folder. Replace SRSDiagFolder with the name of this folder.
   • -?
     Obtain Command-line help for the SRSDiag tool.
   For more details and examples, type the following command at the command prompt:

   SRSDiag -?

Q7: Where do I obtain the SRSDiag tool?

A7: The following file is available for download from the Microsoft Download Center:
Download the SRSDiagnosticsTool.exe package now.

For more information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Q8: What is the rules information repository?

A8: The rules information repository is an XML file. This file contains information that is used by Microsoft Product Support Services to detect problem scenarios that are encountered in SQL Server 2000 Reporting Services. The schema that is used to read this information is stored in the rules schema file.

Warning Do not modify the rules schema file. If you modify this file, the analysis mode of the SRSDiag tool will not work.

Q9: What type of problems can the SRSDiag tool diagnose?

A9: The SRSDiag tool can detect and provide alerts for the following SQL Server 2000 Reporting Services problems:

• File subscription service logon failures occur.
• E-mail subscription service logon failures occur.
• The Kerberos response is too big (error code KRB_ERR_RESPONSE_TOO_BIG).
• The Report Server cannot decrypt the symmetric key.
• The Report Manager and Report Server Virtual Directory settings are incorrect.
• The Report Server database version is incorrect.
• Directory listing is denied
• Internet Server Web Application Manager (IWAM) user-related issues occur.

Q10: How do I troubleshoot the SRSDiag tool?

A10: All error messages, exception messages, and call stacks for the data-gathering mode and for the analysis and diagnosis mode are outputted to the following locations:

• The command prompt
• A data-gathering log file that is created in the data-gathering or analysis folder