To use queries such as this you need to enable Ad Hoc Distributed Queries.

This does have certain security implications, so here's the link to MSDN, which explains about it, and how to enable it, rather than myself.