22,209
社区成员
发帖
与我相关
我的任务
分享大神帮忙看看SQL日志什么意思
反复出现如下语句
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.
请解答一下，以上什么意思我百度没看懂 。
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.
请解答一下，以上什么意思我百度没看懂 。
...全文
请发表友善的回复…
发表回复
还在加载中灬 2015-05-13
- 打赏
- 举报
第三个日志表示，应该有人在使用OpenRowset这个接口功能
newnazi 2015-05-13
- 打赏
- 举报
可是此两句 在一个时间段内反复出现 ，也询问过没有人手动做相关设置
还在加载中灬 2015-05-12
- 打赏
- 举报
呃，我没注意，from 1 to 0
是关闭了这些配置
show advanced options，Ad Hoc Distributed Queries
这两个是远程链接访问需要的开启的配置
这段日志没啥实际内容，不知道怎么详细了
newnazi 2015-05-12
- 打赏
- 举报
菜鸟不懂，能说明的详细一些吗？
还在加载中灬 2015-05-12
- 打赏
- 举报
有人改了 配置信息show advanced options，Ad Hoc Distributed Queries
启动了OpenRowset访问接口
