Microsoft KB Archive/897127

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

Article ID: 897127

Article Last Modified on 5/3/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services

-



INTRODUCTION
This article answers some of the frequently asked questions (FAQ) about the Microsoft SQL Server 2000 Reporting Services Data Gathering and Diagnosis tool (SRSDiag).



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</li> Event logs</li> Local computer network information</li></ul>

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.</li> 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.</li></ul>

Q6: How do I run the SRSDiag tool?

A6: Follow these steps: <ol> At a command prompt, locate the folder where you extracted the SRSDiagnosticsTool.exe files.</li> Use the following syntax to run the SRSDiag tool:

SRSDiag [ -G [ ] | -A    | -?]

Note The SRSDiag tool uses the following parameters: <ul> -G

Run SQL Server 2000 Reporting Services data gathering mode.</li>  

Replace  with the SQL Server Microsoft .NET Framework Provider connection string to connect to the ReportServer database. This parameter is optional.</li> -A

Run SQL Server 2000 Reporting Services data analysis and diagnosis mode.</li>  

Replace  with the path and the file name of the rules schema file.</li>  

Replace  with the path and the file name of the rules XML file.</li>  

The data that was gathered by using the SRSDiag -G command was saved to a folder. Replace  with the name of this folder.</li> -?

Obtain Command-line help for the SRSDiag tool.</li></ul>

For more details and examples, type the following command at the command prompt:

SRSDiag -?

</li></ol>

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:

119591 How to obtain Microsoft support files from online services

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

Additional query words: FAQ

Keywords: kbinfo kbfaq KB897127

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.