Sql server - Where is sql configuration manager in windows 10

How to Use SQL Server Configuration Manager?

Server / September 13, 2019

This topic describes how to to configure startup options that will be used every time the Database Engine starts in SQL Server 2017 by using SQL Server Configuration Manager. For a list of startup options, see Database Engine Service Startup Options.

Limitations and Restrictions

SQL Server Configuration Manager writes startup parameters to the registry. They take effect upon the next startup of the Database Engine.

On a cluster, changes must be made on the active server when SQL Server is online, and will take effect when the Database Engine is restarted. The registry update of the startup options on the other node will occur upon the next failover.

Permissions

Configuring server startup options is restricted to users who can change the related entries in the registry. This includes the following users.

  • Members of the local administrators group.
  • The domain account that is used by SQL Server, if the Database Engine is configured to run under a domain account.

To configure startup options

  1. Click the Start button, point to All Programs, point to Microsoft SQL Server 2017, point to Configuration Tools, and then click SQL Server Configuration Manager.

    Note

    Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows.

    • Windows 10:

Source: docs.microsoft.com