-
Block UDP 1434 to the server using a firewall
-
Using the Server Network Utility, you can open the properties on the TCP/IP net-lib and remove all net-libs. This will essentially block all network connections to the SQL Server but local connections are still possible because of the shared memory netlib which can be used by specifying '(local)' or a period (.) for the server name. For automated configurations you can clear the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\ProtocolList. (For named instances use HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\(instance name)\MSSQLServer\SuperSocketNetLib\ProtocolList). A restart will be required.
- Click the 'hide server' under the TCP/IP netlib on the Server Network Utility and DO NOT leave any other net-libs installed (leaving any others installed will still allow the SQL Server Resolution service to respond). I have experienced strange behavior in that when I enable the Hide option my default TCP Port jumps to 2433. This severely limits the usefulness of this method.
