How to open sql server configuration manager in windows 10?


I am using SQL server Express 2012 in my new windows 10 laptop, now I need to open SQL server configuration manager in windows 10? Where can I find it in Windows 10, in Windows 7, it was easier to navigate and check it in All Programs -> SQL server 2012 -> SQL server configuration manager, but in Windows 10 I cannot find it.

Where can I find it in windows 10? I tried to check in All programs but wasn't able to find it.

Thanks


Asked by:- manish
1
: 19689 At:- 9/9/2018 5:54:06 PM
SQL sql server configuration manager in windows 10



add comment to question



2 Answers
profileImage Answered by:- neena

Here are the possible ways to open SQL server configuration manager in Windows 8, Windows 10 or Windows 11:

  1. Go to Control Panel -> Administrative tools -> Open Computer Management ->Services and Application -> SQl server configuration manager, below is the screenshot
    sql-server-configuration-manager-in-windows-10-min.png
  2. Another way is naviagte to "C:\Windows\SysWOW64" and find 'SQLServerManager{Version}.msc'
    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     C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012     C:\Windows\SysWOW64\SQLServerManager11.msc

    SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager<version>.msc file (such as SQLServerManager13.msc for SQL Server 2016 (13.x)) to open Configuration Manager.

Thanks.
2
At:- 9/10/2018 11:53:16 AM Updated at:- 12/1/2022 7:22:27 AM
First approach looks simpler to me, thanks. 0
By : manish - at :- 9/12/2018 11:05:53 AM


comment to above answer
profileImage Answered by:- vikas_jk

For SQL Server 2017 it is : C:\Windows\SysWOW64\SQLServerManager14.msc
For SQL Server 2016 it is : C:\Windows\SysWOW64\SQLServerManager13.msc
For SQL Server 2016 it is :C:\Windows\SysWOW64\SQLServerManager12.msc

and to add it back to the start menu, copy it from the original location provided above and paste it to

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2017\Configuration Tools\

Note: ProgramData folder is hidden, you can show hidden folders in Windows explorer by navigating to "View"-> "Options"-> "Select View tab"-> under hidden "Files and folders" -> Select "Show hidden files, folders and drive"

This would put back the configuration manager under start menu.

If you are using older version of SQl server like 2008, then from SQL Server 2008 Setup, you have to select "Client Tools Connectivity" to install SQL Server Configuration Manager OR probably "repair" from installation wizard will work.
0
At:- 9/2/2020 2:41:22 PM


comment to above answer

Patreon Become a Patron


Login/Register to answer
Or
Register directly by posting answer/details

Full Name *

Email *




By posting your answer you agree on privacy policy & terms of use

Related Articles
3126
SQL Server Management Studio (SSMS) Alternatives (Mac, Windows, Linux)
15240
Import csv into SQL server (with query OR without query using SSMS)

Subscribe Now

Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly


Related Questions