[SDP 3] [155888db-ad84-4e39-a4e1-f6e6c3b185b4] Information that is collected by SQL RS Diagnostics Collector

Article translations Article translations
Article ID: 2773194 - View products that this article applies to.
Expand all | Collapse all

Summary

The SQL RS Diagnostics Collector for Windows Server 2003 R2, Windows Vista, Windows Server 2008, Windows Server 2008 R2, Windows 7, Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2 collects diagnostic information that is useful in troubleshooting a broad class of issues that involve Microsoft SQL Server Reporting Services (SSRS). This collector is used to collect information for both the Native mode and the Microsoft SharePoint mode of SSRS.

The SQL RS Diagnostics Collector supports the following versions of SQL Server:
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012

More information

Prerequisite software

There are different prerequisites to run diagnostic packages, depending on the operating system of the destination computer. The diagnostic package will automatically check your computer for these prerequisites, and then start if the prerequisites are already installed. If the prerequisites are not already available on the computer, you are prompted to install them. The Microsoft Automated Troubleshooting Service (MATS) can also install the required software for you. For example, if Windows PowerShell is not present on the destination computer, MATS will install it automatically. For more information, see the following article in the Microsoft Knowledge Base:
2598970 Information about the Microsoft Automated Troubleshooting Services and Support Diagnostic Platform
Required Windows rights
You must have administrative rights on the computer from which you execute the SQL RS Diagnostics Collector.
Steps that are involved
The SQL RS Diagnostics Collector must be manually run on all computers that are involved in the SSRS configuration. For example if the SSRS is a scale-out deployment, then the SQL RS Diagnostics Collector should be manually run on all computers that are involved in the scale-out configuration. Similarly, on a SharePoint-integrated mode, the SQL RS Diagnostics Collector should be run on SharePoint.
SQL Server security requirements
The SQL RS Diagnostics Collector discovers all instances of reporting services that are installed on the computer where the diagnostics tool is run. As part of the data collection process, the SQL RS Diagnostics Collector tries to connect to each SSRS catalog database server to which the SSRS instances connect, and then collects information from the ReportServer catalog database. Database connections are made by using Windows authentication. In order to start the SQL RS Diagnostics Collector, you must have a Windows logon that is a member in the sysadmin fixed server role.
SharePoint security requirements
The SQL RS Diagnostics Collector discovers all instances of reporting services that are installed on the computer. If the computer hosts just the SharePoint software that SSRS integrates to, then the SQL RS Diagnostics Collector collects information about the SharePoint configuration, installed websites, and so on. In order to execute the SQL RS Diagnostics Collector, you must have a Windows logon that is a member of the administrator group on the computer.

Information that is collected bythe SQL RS Diagnostics Collector

System event log
Note The SQL RS Diagnostics Collector collects events from the previous 30 days.
Collapse this tableExpand this table
DescriptionFile name
System event log in TXT, CSV, and EVT or EVTX formats<COMPUTER_NAME>_ evt_System.csv
<COMPUTER_NAME>_ evt_System.txt
<COMPUTER_NAME>_ evt_System.(evt or evtx)
Application event log
NoteThe SQL RS Diagnostics Collector collects events from the previous 30 days.
Collapse this tableExpand this table
DescriptionFile name
Application event log in TXT, CSV, and EVT or EVTX formats<COMPUTER_NAME>_ evt_Application.csv
<COMPUTER_NAME>_ evt_Application.txt
<COMPUTER_NAME>_ evt_Application.(evt or evtx)
Registry information that is related to reporting services configuration
Collapse this tableExpand this table
DescriptionFile name
Collect registry key and child keys under HKLM:\System\CurrentControlSet\Services\TCPIP\Parameters<COMPUTER_NAME>_RS_Registry.XML
Collect registry key and child keys under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa<COMPUTER_NAME>_RS_Registry.XML
Information from all services that are installed on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect information about services that are installed on the destination computer<COMPUTER_NAME>_MiscProperties.XML
Information from the ULS logs from the SharePoint instance on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the ULS logs from the SharePoint that is installed on the destination computer<COMPUTER_NAME>.<INSTANCE_NAME>_Date.log
Information from the SSRS Logs from all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the SSRS logs from the SSRS instances that are installed on the destination computer<COMPUTER_NAME>.<INSTANCE_NAME>_ReportServerService_GUID.log
Information from the SSRS ReportServer.Config file from all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the RSReportServer.Config file from the SSRS instances that are installed on the destination computer<COMPUTER_NAME>.<INSTANCE_NAME>_RSReportserver.config
Information from the Web.config file from all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the Web.config file from the ReportServer and ReportManager directories from all SSRS instances that are installed on the destination computer<COMPUTER_NAME>.<INSTANCE_NAME>_web.config
Information from the SSRS configuration for all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the configuration information that is stored in the SSRS Catalog database for all SSRS instances that are installed on the destination computer<COMPUTER_NAME>.<INSTANCE_NAME>ConfigInfo.XML
Information from the execution information for all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the execution information that is stored in the SSRS Catalog database for all SSRS instances that are installed on the destination computer<COMPUTER_NAME>.<INSTANCE_NAME>ExecutionInfo.XML
Information from the SPN configuration for all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the SPN configuration information for the SSRS service account that is running the SSRS instance (if the server is running SharePoint)<COMPUTER_NAME>_RS_SPN.XML
Information from the HTTP error logs on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the HTTP error logs on the destination computer<COMPUTER_NAME>.httperrX.log
Information from the HTTP logs for all SSRS instances on the destination computer
Collapse this tableExpand this table
DescriptionFile name
Collect the HTTP logs that are generated if the attribute is turned on the SSRS Reportserver.config files<COMPUTER_NAME>.<INSTANCE_NAME>_Http.log

Properties

Article ID: 2773194 - Last Review: October 25, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 2005 Reporting Services
  • Microsoft SQL Server 2008 R2 Reporting Services
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Evaluation Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Parallel Data Warehouse
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Standard
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced KB2773194

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com