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






1 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





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