Where to find SQL Configuration Manager in Windows 10 and 11

👤 Diwas Poudel 🕒 16 Sep 2023 📁 TECH

Your colleagues might have advised you to carry out specific tasks within SQL Configuration Manager. If you are new to SQL Server and Configuration Manager and are unsure about where to find it, don't worry. If this is the issue you're facing, Ourtechroom is here to provide you with guidance and assistance.

SQL Configuration Manager

SQL Configuration Manager is a Microsoft Windows tool used for managing SQL Server instances, network protocols, setting service accounts, viewing server properties, and connectivity. It is utilized for performing administrative tasks related to SQL Server.

This manager helps ensure that SQL Server functions properly, maintains security, and is also used for troubleshooting if any issues arise. It is generally utilized by developers, database administrators, and other IT professionals.

When you install SQL Server, this manager is also installed.

Different Ways of Finding SQL Configuration Manager

Lets look different ways of Finding location of SQL Configuration Manager

Using Computer Management

Steps:

Goto Run by pressing Win + R from keyboard
Type "compmgmt.msc" without quotes. And press Ok button. This will open Computer Management Windows

fig. Type compmgmt.msc in run dialog box
On the left pane expand Services and Applications
There again expand SQL Server Configuration Manager.

fig. SQL Server Configuration Manager in Computer Management Tools

Here you will get:

SQL Server Services
SQL Server Network Configuration
SQL Native Client 11.0 Configuration
Azure Extension for SQL Server
SQL Server Network Configuration
SQL Native Client 11.0 Configuration
Azure Extension for SQL Server.

Then, proceed to perform the task suggested by your colleagues.

Using MMC

MMC stands for Microsoft Management Console.

Here are the steps for finding SQL Configuration Manager using MMC.

Goto Run by press Win + R and type "mmc" without quotes and press Ok button. This will open Microsoft Management Console.
Then goto File > Add/Remove Snap-in

fig. File >Add/Remove Snap in
Select "SQL Server Configuration Manager" from the right side and click on Add button

fig. Adding SQL Server Configuration Manager
Then Click on Ok to add the snap-in to the MMC.

fig. Click on Ok button
Now you will see "SQL Server Configuration Manager" under console root as shown below.

fig. SQL Server Configuration Manager in Console Root

This manager helps you to ensures that SQL server functions properly, maintains security and also used for troubleshooting if any issue arise. Generally found to be used by Developers, Database Administrators and other IT professionals.