Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
Answer: I just happen to participate in the interview question panel recently. When this question was brought up by one of the interviewer, I suggested that it should not be included. I believe this question is not fair to users. First of all – not everyone knows everything and there are some questions which should be just good for Google and they should not be asked in an interview. After long argument, I was able to convince the interviewer to remove this from grading the candidate, however, they still wanted to ask in the interview. Well, some battles we win and some we lose, I finally let settle at the midway. Now let us see the answer of this question.
Well, after SQL Server 2008, SQL Server Configuration Manager is no more available in the start menu as an individual program. It no more stands alone as it used to be previously. It is available via search or via run in Windows.
Here is what you should do if you are looking for SQL Server Configuration Manager.
Go to Search in Windows and type following based on the version of SQL Server.
|SQL Server 2008||SQLServerManager10.msc|
|SQL Server 2012||SQLServerManager11.msc|
|SQL Server 2014||SQLServerManager12.msc|
|SQL Server 2016||SQLServerManager13.msc|
Once you enter commands in the search engine it will bring up the configuration manager. You can click on it and it will open SQL Server Configuration Manager.
Reference: Pinal Dave (https://blog.sqlauthority.com)