I've been using the built in Routing and Remote Access (which can be configured for PPTP or L2TP). As long as you follow the wizzards, you can't really break...
(local) would be a SQLServer term that referrs to the current machine. I'd expect it to use the preferred connection method (TCP/IP or Named Pipes depending on the install).