Activar 'Ad Hoc Distributed Queries' para consultas con OPENROWSET o OPENDATASOURCE

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1

GO

RECONFIGURE