SQL ERROR :Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component Ad Hoc Distributed Queries

SQL ERROR :Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component Ad Hoc Distributed Queries

Solution /Resolution :
you will have to wirte a t-sql query to allow access as below sample




EXEC sp_configure 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'ad hoc distributed queries', 1

RECONFIGURE WITH OVERRIDE

GO

Thanks.