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
: 6645 At:- 9/9/2018 5:54:06 PM
SQL sql server configuration manager in windows 10






2 Answers
profileImage Answered by:- neena

Here are the possible ways to open SQL server configuration manager in Windows 10 :

  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 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.

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


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






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

Subscribe Now

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