Table of Contents
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.
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)).
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.
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.
To open SQL Server Configuration Manager, type SQLServerManagerversion>.msc in the Search charm’s Apps section, such as SQLServerManager13.msc, and then press Enter.
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.
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.
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.
This website uses cookies.