A while ago Logitech released a version of SqueezeCenter for Windows Home Server. It was nice to install it on our server, and not have to worry about keeping another computer running, just for access to our music. I have been having a problem with the installation though. If the server is restarted, the SqueezeCenter is not able to successfully startup. It appeared that the SqueezeSQL service wasn't starting fast enough so SqueezeCenter service wasn't able to connect to the database.
Since we are using Window Media Center, we have a faster computer that is always running, that can be used to run the SqueezeCenter software. The music is still on the server, so there is more network traffic when playing local content, but things are working pretty well.