SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration:

SELECT spresults.* 
FROM OPENROWSET('SQLNCLI', 'Server=192.168.0.7;Trusted_Connection=yes;',
                ' Exec DBPharmaUltimus.dbo.uspMIS_ExportSalesData ''2015-07-28''') AS spresults

Error appears because Ad Hoc Distributed Queries configuration parameter is disabled.

To enable Ad Hoc Distributed Queries follow the next steps:

First, make sure that you can see all SQL configuration settings when running sp_configure command by enabling the 'show advanced options' configuration parameter:

1. sp_configure 'show advanced options',1  
2. reconfigure  

After this, enable the 'Ad Hoc Distributed Queries' by running the following statements:

1. sp_configure 'Ad Hoc Distributed Queries',1  
2. reconfigure  

Executing sp_configure command you can see that the parameter is enabled:

 Ref:

Hello,

And also here a pretty clear error message: By security distributes ad hoc querys are disable; contact your DBA if it's required to change this.

If you have sysadmin permission, you can change this with sp_configure. If you are not sysadmin, you will need to talk kindly with your DBA: