Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server on Windows
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 is enabled on this service. For more information, see Configure usage and diagnostic data collection for SQL Server (CEIP).
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 sends information to either Microsoft or your error server if a serious failure occurs. For more information on Error Reporting, see Configure usage and diagnostic data collection for SQL Server (CEIP).
To change this value, in SQL Server Management Studio Object Explorer, right-click your server, select Properties, and then select 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.
Lock Pages In Memory
Applies to: SQL Server 2019 (15.x) and later versions.
Grants the Lock pages in memory privilege to the SQL Server Database Engine service account.
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, see Database Engine 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.