As the other replies indicated, this is about security, not addressing (and not really about SQL specifically either), and there are lot of possible security gates between A and B that could be stopping you (and it's likely not just one thing either).

The first thing to do is to establish whether you can make *ANY* connection between the two boxes. So, can you ping workstation B from workstation A? Can you make any other kind of connection from A to B?