反复出现如下语句
05/12/2015 15:17:07,spid165,未知,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
05/12/2015 15:17:07,spid165,未知,Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 0. Run the RECONFIGURE statement to install.
05/12/2015 14:46:20,spid196,未知,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'<c/> search for 'Ad Hoc Distributed Queries' in SQL Server Books Online.
请解答一下,以上什么意思我百度没看懂 。
------解决思路----------------------
有人改了 配置信息show advanced options,Ad Hoc Distributed Queries
启动了OpenRowset访问接口
------解决思路----------------------
呃,我没注意,from 1 to 0
是关闭了这些配置
show advanced options,Ad Hoc Distributed Queries
这两个是远程链接访问需要的开启的配置
这段日志没啥实际内容,不知道怎么详细了
------解决思路----------------------
第三个日志表示,应该有人在使用OpenRowset这个接口功能