Pages

Wednesday, August 14, 2013

SQL SERVER – Fix : Error : 15281 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 | Journey to SQL Authority with Pinal Dave

Error : Msg 15281, Level 16, State 1, Line 3 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. For more… Continue Reading...

Source: SQL SERVER – Fix : Error : 15281 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 | Journey to SQL Authority with Pinal Dave

No comments:

Post a Comment