Hey Dave,

By default the adhoc queries are turned off in SQL 2005. I think you stated that you can run open queries but I'd double check the following.

sp_configure 'show advanced options', 1

reconfigure with override

GO

sp_configure 'Ad Hoc Distributed Queries', 1

reconfigure