Home » SQL Server Admin » SQL Server Basics » SQL Server Configuration Manager

SQL Server Configuration Manager

What is SQL Server Configuration Manager?

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. It is a Microsoft Management Console snap-in that is available from the Start menu we can use.

The SQL Server Configuration Manager comes pre-installed with SQL Server. It is a Microsoft Management Console snap-in that we can use to added to any other Microsoft Management Console display or launched from the Start menu.

SQL Server Configuration Manager installation path on the C drive?

To open Configuration Manager, the Microsoft Management Console (mmc.exe) requires the SQLServerManager.msc file (such as SQLServerManager13.msc for SQL Server 2016 (13.x)).

SQL SERVER CONFIGURATION MANAGER
Version Path
SQL Server 2019 C:\Windows\SysWOW64\SQLServerManager15.msc
SQL Server 2017 C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016 C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014 (12.x) C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012 (11.x) C:\Windows\SysWOW64\SQLServerManager11.msc

SQL Server Configuration Manager does not appear as an application in recent versions of Windows since it is a snap-in for the Microsoft Management Console programme rather than a standalone programme.

SQL Server Configuration Manager on Windows 10 or 11?

Navigate to the file location for your version stated above to open SQL Server Configuration Manager. The Configuration Manager is opened by double-clicking SQLServerManager15.msc. You may also use the right-click menu to pin SQLServerManager15.msc to the Start Page or Task Bar.

SQL Server Configuration Manager on Windows 8?

To open SQL Server Configuration Manager, type SQLServerManagerversion>.msc in the Search charm’s Apps section, such as SQLServerManager13.msc, and then press Enter.

How are SQL Server Configuration Manager and SQL Server Management Studio used?

To view and update various server settings, SQL Server Configuration Manager and SQL Server Management Studio employ Window Management Instrumentation (WMI). WMI provides a single approach to interact with the API calls that manage the registry activities requested by SQL Server tools, as well as providing greater control and manipulation over the SQL Server Configuration Manager snap-in component’s selected SQL services.

“Connect to Another Machine” (SQL SCM) to start, stop, pause, restart, or configure services on another computer using SQL Server Configuration Manager can be done.

How SQL Server Configuration Manager is used for Network Protocols?

You can use SQL Server Configuration Manager to set up server and client network protocols, as well as connectivity settings. You normally don’t need to update the server network connections once the relevant protocols have been enabled. If you need to alter the server connections so SQL Server listens on a specific network protocol, port, or pipe, you can use SQL Server Configuration Manager.

Configure the Windows Firewall to Allow SQL Server Access for details on permitting protocol access over a firewall.

Different configurations by SQL Configuration Manager:

  1. You can use SQL Server Configuration Manager to control server and client network protocols, including forcing protocol encryption, viewing alias properties, and enabling and disabling protocols.
  2. You can use SQL Server Configuration Manager to create or remove aliases, adjust the order in which protocols are used, and inspect server alias properties, such as:
    • Server Alias – This is the server alias for the computer that the client is connecting to.
    • The network protocol used for the configuration item is called protocol.
    • Connection parameters – For network protocol settings, these are the parameters linked with the connection address.

SQL Server Configuration Manager is very handy in Managing Services like

Changing the Accounts Used by the Services

Manage Server & Client Network Protocols like Ports used.

 

Leave a Reply

Your email address will not be published. Required fields are marked *