how to use sqlserver2008 to search in files -优快云博客

本文将详细解释如何解决在SQL Server中由于安全配置导致的AdHocDistributedQueries组件被禁用的问题，并提供详细的步骤进行解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

example:
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=No;DATABASE=D:\Data\FullIdList'
,'select * from [b.txt]')

problem 1:
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 information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.
solution :
--0 show sys.configurations, if the value of 'Ad Hoc Distributed Queries' is 0 ,go ahead
SELECT * FROM sys.configurations
ORDER BY name ;
--1. Use below script to enable to update the configurations:
sp_configure 'show advanced options',1
reconfigure
--2.Enable 'Ad Hoc Distributed Queries':
sp_configure 'Ad Hoc Distributed Queries',0
reconfigure

problem 2:
solution :
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\TEXT]