Check that you have
a) remote connections enable for named pipes in is enabled in SQL Server Surface Area Manager > Surface Area Configuration for Services and Connections
b) OPENROWSET is enabled in SQL Server Surface Area Manager > Surface Area Configuration & Features
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)