Post reply

SQL Server 2014 configuration manager missing after updating on Windows 10

  • October 10, 2017 at 2:41 am

    #340739

    I am a graduate student and using SQL Server 2014 for my practice purposes. Recently got an update on Windows 10, and after that I couldn't find my "SQL Server 2014 configuration manager". The every other tools are visible and can use SSMS without any issues. 
    I appreciate if someone could give me the solution to get it back. And this is my first ever question on this forum, please forgive me if there is any particular format for asking questions.

    Thanks in advance.

  • October 10, 2017 at 3:03 am

    #1962963

    How are you trying to find it, in the start menu navigation? Try simply trying "SQL Server" into the start Menu, it should show up. Alternatively, you could open it by go to Run (Windows Key + R) and typing SQLServerManagerx.msc where x is the version number of your SQL Server (2014 is Version 12).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 10, 2017 at 3:18 am

    #1962965

    Thanks for the quick reply Thom. 
    I have already tried both the ways you have mentioned above, using .msc in run and searching in the start menu. Right now I am going into the "services" to turn on the Servers to run, so not having problem to log in. But I couldn't figure out why I can't see the configuration manager, infact I can see the reporting services configuration manager for SQL server 2014. I was able to see both configuration managers before the update, but one got vanished after couple of updates(I didn't practice/use SQL server in between these windows 10 updates, so not sure which update is causing this issue). It's really weird.

  • October 10, 2017 at 3:33 am

    #1962968

    sudhakar.11sept - Tuesday, October 10, 2017 3:18 AM

    Thanks for the quick reply Thom. 
    I have already tried both the ways you have mentioned above, using .msc in run and searching in the start menu. Right now I am going into the "services" to turn on the Servers to run, so not having problem to log in. But I couldn't figure out why I can't see the configuration manager, infact I can see the reporting services configuration manager for SQL server 2014. I was able to see both configuration managers before the update, but one got vanished after couple of updates(I didn't practice/use SQL server in between these windows 10 updates, so not sure which update is causing this issue). It's really weird.

    Are you saying that using Run and entering SQLServerManager12.msc doesn't work? What message is returned? If you navigate to the folder C:\Windows\SysWOW64, can you see any files named SQLServerManagerx? If not, this implies that SQL Server isn't installed on your Machine.

    Note, that Microsoft does state the the "application" does not appear in the start menu, as it is a snap in for the Microsoft Management Console (see here: https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager).

    The only option I can think of is go to Run and type mmc.exe and hit return. In the optioned application click File -> Add/Remove Snap-in. Scroll down in the Available snap-ins to SQL Server Configuration Manager and click Add > and then OK. You'll then have a new node under the Console Root on the left hand side for SQL Server.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 10, 2017 at 9:24 am

    #1963043

    Hey Thom, sorry for the late reply. I could see the services using .msc now. I was not entering the proper version before, was entering the released year. Thank you so much for your replies. But do you have any idea why I could not see it in my start menu ?

  • October 10, 2017 at 9:32 am

    #1963046

    sudhakar.11sept - Tuesday, October 10, 2017 9:24 AM

    Hey Thom, sorry for the late reply. I could see the services using .msc now. I was not entering the proper version before, was entering the released year. Thank you so much for your replies. But do you have any idea why I could not see it in my start menu ?

    Because you won't in Windows 8 onwards, it's not an application, as per the link I provided in my earlier post.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 10, 2017 at 10:01 am

    #1963055

    I checked that link, but I was using and was able to see the configuration manager tool in my windows 10 earlier. I am using SQL server 2014 on my windows 10 the whole time. Anyways, I could pin it to start menu now with the link you have provided. Will use that, thank you so much Thom. Really appreciate the replies. 🙂 Have a good one !

  • October 10, 2017 at 10:14 am

    #1963065

    sudhakar.11sept - Tuesday, October 10, 2017 10:01 AM

    I checked that link, but I was using and was able to see the configuration manager tool in my windows 10 earlier. I am using SQL server 2014 on my windows 10 the whole time. Anyways, I could pin it to start menu now with the link you have provided. Will use that, thank you so much Thom. Really appreciate the replies. 🙂 Have a good one !

    It was an due to an update they did (not sure what). Pinning, however, is your best bet. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy