INF: How to Set Up Watson Error Reporting on SQL Server 2000 Service Pack 3 Servers (328446)

SUMMARY

Microsoft SQL Server 2000 Service Pack 3 (SP3) introduces an error reporting feature for:

The SQL Server database engine.
The SQL Server Agent.
Analysis Services.

If you turn on the error reporting feature, SQL Server, the SQL Server Agent, and Analysis Services, or all of them, are configured to send a report to Microsoft automatically if a fatal error such as an exception occurs in a SQL Server database engine, the SQL Server Agent, or Analysis Services.

MORE INFORMATION

By default, Microsoft SQL Server error reporting is turned off. You can turn error reporting on:

When you install SQL Server Service Pack 3 (SP3).
By using the SQL Server Enterprise Manager Server Properties dialog box.
By using the Analysis Manager Server Properties dialog box for Analysis Services.

To turn on error reporting by using SQL Server Enterprise Manager or Analysis Manager, follow these steps:

Click to select the name of the server.
Right-click the server name, and then click Properties.
Click to select the Enable Error Reporting Feature check box.

To turn off error reporting by using SQL Server Enterprise Manager or Analysis Manager, follow these steps:

Click to select the name of the server.
Right-click the server name, and then click Properties.
Click to clear the Enable Error Reporting Feature check box.

If you turn on the error reporting feature, SQL Server automatically sends a report to Microsoft when a fatal error occurs in the SQL Server database engine, the SQL Server Agent, or Analysis Services. Microsoft uses the error reports to improve SQL Server functionality and treats all the information 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. For more information about setting up a Corporate Error Reporting Server, visit the following Microsoft Web site:

http://www.microsoft.com/resources/satech/cer/

The error report contains the following information:

The condition of SQL Server when the problem occurred.
The operating system version and the 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 files, of the process that caused the error to occur.

For the Microsoft error reporting data collection policy, visit the following Microsoft Web site:

http://oca.microsoft.com/en/dcp20.asp