Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Error Reporting (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

Use the Error Reporting page of the Microsoft® SQL Server™ 2000 (64-bit) Installation Wizard to enable error reporting.

Microsoft SQL Server error reporting is disabled by default. You can enable it during installation through SQL Server Setup or Analysis Services Setup, or after installation through the SQL Server Enterprise Manager Server Properties dialog box or the Analysis Manager Server Properties dialog box (from a remote client running SQL Server 2000 SP3).

Enabling error reporting while running SQL Server Setup or Analysis Services Setup allows SQL Server error reporting for the SQL Server database engine, SQL Server Agent, and SQL Server Analysis Services. If you run SQL Server Setup and enable error reporting, and later run Analysis Services Setup, error reporting will automatically be enabled for the Analysis Services, as well as the SQL Server database engine and SQL Server Agent.

If you enable this feature, SQL Server is configured to send a report to Microsoft automatically if a fatal error occurs in the SQL Server database engine, in SQL Server Agent, or in SQL Server Analysis Services. Microsoft uses error reports to improve SQL Server functionality, and treats all information as confidential.

Information about errors is sent over a secure (https) connection to Microsoft, where it is stored with limited access. Alternatively, this information can be sent to your own Corporate Error Reporting server. See this Microsoft Web site for more information about setting up a Corporate Error Reporting server. The error report contains the following information:

  • The condition of SQL Server when the problem occurred.

  • The operating system version and computer hardware information.

  • Your Digital Product ID, which can be used to identify your license.

  • The network IP address of your computer.

  • Information from memory or file(s) of the process that caused the error.

Microsoft does not intentionally collect your files, name, address, e-mail address, or any other form of personal information. The error report can, however, contain customer-specific information from the memory or file(s) of the process that caused the error. Although this information can potentially be used to determine your identity, Microsoft does not use this information for that purpose. For the Microsoft error reporting data collection policy, see this Microsoft Web site.

If you enable error reporting and a fatal error occurs, you may see a response from Microsoft in the Windows Event log that points to a Microsoft Knowledge Base article on a particular error. A response may look similar to the following example:

Source = MSSQLServerOlapServicesDW

EventID = 1010

data =http://support.microsoft.com/support/misc/kblookup.asp?id=

To disable error reporting for the SQL Server database engine and SQL Server Agent, go to SQL Server Properties (General Tab) in Enterprise Manager (from a remote client running SQL Server 2000 SP3) and clear the Enable the error reporting feature check box. To disable error reporting for Analysis Services, go to Server Properties in Analysis Manager (from a remote client running SQL Server 2000 SP3) and clear the Enable the error reporting feature check box. If error reporting is enabled for both SQL Server (database engine and SQL Server Agent) and Analysis Services, you must disable error reporting for SQL Server and Analysis Services individually.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.