So now I've got to gin up a web service layer when all I wanted to do was connect to a SQL server on the LAN. Got it.
Short answer? Yes -- that way you can improve how you use SQL Server (query tuning, calling a stored procedure instead of doing a bunch of DML, etc.) without having to update the code on all the clients.