Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I went to check a network protocol setting for SQL Server the other day on my (newish laptop) and was disappointed.
This is Windows 10 and on this machine, I’d installed SQL Server 2014, 2016, and 2017. I thought that at least SQL Server 2014 had the SQL Server Configuration Manager installed, but it appears not. I know that this has been a tool that sometimes gets hidden in recent versions, but I was sure I’d seen it here.
Either I’m wrong or Windows 10 has changed.
In any case, the Computer Management MMC plugin has it. You can run this in a couple ways. First, hit the Start menu and type “Computer Man”. You’ll get something like this and can run this:
The other choice is to his Win+R (run) and type “compmgmt.msc”. Both will get you here:
If you now expand the Services and Applications, you’ll see the SQL Server Configuration Manager and the various items underneath it. For me, the top one (most recent?) was the SQL Server 2017 version. The others were below as other snap-ins.
The good thing about this is I can also manage local users and see the local logs, things I sometimes need when configurating SQL Server.
An easy post that solves a common problem, and shows I know some tips and tricks. How would you rewrite this post? You could show this knowledge with a quick 10 minutes of your time.