Installing SQL Server on Windows? Don’t Forget These 2 Useful Switches

A few days ago on Twitter, I wrote:

Couldn't connect to new SQL Server install because I forgot to enable TCP/IP. I'm the lead author for a Microsoft Press book about SQL Server administration.

Aside from demonstrating that checklists are helpful, it did raise an interesting point about why this isn't a configurable option in the SQL Server Setup tool. After all, most people using SQL Server today are not connecting to it locally on the same machine, and the Linux and Docker container versions of SQL Server already have TCP/IP enabled.