SQL Server Properties (Advanced Tab)

SQL Server Configuration Manager

The following properties appear on the Advanced tab by default. If custom properties are defined, they also appear on this tab, with their values.

Options

Clustered

Indicates if this service is installed as a resource of a clustered server.

Customer Feedback Reporting

Indicates whether Service Quality Monitoring has been enabled on this service. For more information on Customer Feedback Reporting, search Books Online for the topic, "Error and Usage Report Settings."

Data Path

Displays the path to the SQL Server binaries for this installation of SQL Server.

Dump Directory

Displays the location where memory dumps are placed in case of an error.

Error Reporting

When set to Yes, the Dr. Watson program forwards information to either Microsoft or your error server if a serious failure occurs. For more information on Error Reporting, search Books Online for the topic, "Error and Usage Report Settings." To change this value, in SQL Server Management Studio Object Explorer, right-click your server, click Properties, and then click the Misc. Server Settings page. The options are presented in the Information Reporting area.

File Version

Displays the version of the SQL Server executable.

Install Path

Displays the path to the SQL Server binaries for this installation of SQL Server.

Instance ID

Indicates the SQL Server instance that used this service.

Language

Displays the default language for server messages.

Registry Root

Displays the location of the registry keys used by this application.

Service Pack Level

Displays the service pack level of this instance of SQL Server.

SKU Name

Displays the product stock keeping unit (SKU), sometimes called the product edition.

Startup Parameters

Lists any startup parameters that are used by this instance of SQL Server. Parameters are separated by semi-colons. The default parameters include the paths to the data file for the master database (master.mdf), the log file for the master database (mastlog.ldf), and the error log file. For the syntax of startup parameters, search Books Online for the topic Using the SQL Server Service Startup Options.

Stock Keeping Unit

Displays the product stock keeping unit (SKU) number.

Version

Displays the version number of this instance of SQL Server.

Virtual Server Name

Virtual Server Name when SQL Server is installed on a clustered server.