EDUDOTNET

Monday, October 17, 2016

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries'

When I try to run query with "SELECT * FROM OPENROWSET" than I`m getting error: "Msg 15281, Level 16, State 1, Procedure GetUserData, Line 10SQL 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 for this server. A system...