Cause: Occurs when replicating data from a remote server to local
SQL Server blocked access to STATEMENT ' openrowset/opendatasource ' of component ' Ad Hoc distributed Queries ' because this component was shut down as part of this server's security configuration. System administrators can enable ' Ad Hoc distributed Queries ' by using sp_configure. For more information about enabling ' Ad Hoc distributed Queries '
Error, so search online, find the following workaround:
Enable AD Hoc distributed Queries:
[SQL]View Plaincopyprint?
- exec sp_configure ' show advanced options ' ,1  
- reconfigure
- exec sp_configure ' ad hoc distributed queries ' ,1  
- Reconfigure
When you are finished using, close ad Hoc distributed Queries:
[SQL]View Plaincopyprint?
- exec sp_configure ' ad hoc distributed queries ' ,0  
- reconfigure
- exec sp_configure ' show advanced options ' ,0  
- Reconfigure
This person verified success!