I ran into a similar issue where I needed to connect to an MSDE instance on another server. The server was running multiple instances, so I couldn't figure out which port I needed to connect to. I ended up using sql enterprise manager on another server, and when registering the new connection I added the name of the instance as SERVERNAME\INSTANCENAME and it connected right up using pipes.
Hope this might help someone.