Wednesday, November 25, 2015

SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’

To enable ‘Ad Hoc Distributed Queries’:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

No comments: