SQL Server blocked access to STATEMENT ÔÇÜOpenRowset/OpenDatasourceÔÇÖ

Udost─Öpnij na:

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 for this server. A system administrator can enable the use of ÔÇÜAd Hoc Distributed QueriesÔÇÖ by using sp_configure

 

ROZWI─äZANIE:

EXEC sp_configure ÔÇÜallow updatesÔÇÖ, 0
RECONFIGURE

EXEC sp_configure ÔÇÜshow advanced optionsÔÇÖ, 1
RECONFIGURE WITH OVERRIDE –really reconfigure
GO
EXEC sp_configure ÔÇÜad hoc distributed queriesÔÇÖ, 1
RECONFIGURE WITH OVERRIDE –really reconfigure
GO