Select the product you need help with
Information that is collected by SQL RS Diagnostics CollectorArticle ID: 2773194 - View products that this article applies to. SummaryThe SQL RS Diagnostics Collector for Windows Server 2003 R2, Windows Vista, Windows Server 2008, and Windows Server 2008 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:
More informationPrerequisite softwareThere 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
(http://support.microsoft.com/kb/2598970/
)
Information about the Microsoft Automated Troubleshooting Services and Support Diagnostic Platform Required Windows rightsYou must have administrative rights on the computer from which you execute the SQL RS Diagnostics Collector.Steps that are involvedThe 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 requirementsThe 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 requirementsThe 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 CollectorSystem event logNote The SQL RS Diagnostics Collector collects events from the previous 30 days.Collapse this table
Application event logNoteThe SQL RS Diagnostics Collector collects events from the previous 30 days.Collapse this table
Registry information that is related to reporting services configurationCollapse this table
Information from all services that are installed on the destination computerCollapse this table
Information from the ULS logs from the SharePoint instance on the destination computerCollapse this table
Information from the SSRS Logs from all SSRS instances on the destination computerCollapse this table
Information from the SSRS ReportServer.Config file from all SSRS instances on the destination computerCollapse this table
Information from the Web.config file from all SSRS instances on the destination computerCollapse this table
Information from the SSRS configuration for all SSRS instances on the destination computerCollapse this table
Information from the execution information for all SSRS instances on the destination computerCollapse this table
Information from the SPN configuration for all SSRS instances on the destination computerCollapse this table
Information from the HTTP error logs on the destination computerCollapse this table
Information from the HTTP logs for all SSRS instances on the destination computerCollapse this table
PropertiesArticle ID: 2773194 - Last Review: March 19, 2013 - Revision: 1.0 Applies to
| Article Translations
 |
Back to the top
