In trying to install SQL Server completely "hands free" I struck a snag - by default the TCP/IP protocol is installed, but the interfaces are all "Enabled=false", which would require a manual step to enable them. Naturally - PowerShell to the rescue! To view the basic post-install state, open up...