提示:
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.
我在SQL Server Surface Area Configuration里面把Enable OPENROWSET AND OPENDATASOURCE Suppor的选项打开了,但是还是提示这个错误...
应该怎么设置呢?
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.
我在SQL Server Surface Area Configuration里面把Enable OPENROWSET AND OPENDATASOURCE Suppor的选项打开了,但是还是提示这个错误...
应该怎么设置呢?
解决方案 »
- 按逗号截取字符并放入临时表问题
- c/s程序,想做一个导入导出的功能[导入导出到access文件中]。在客户端能实现吗?我是说access文件放到客户端机器上?
- 请教一linked server的问题,谢谢.
- win2003 安装sqlsever2000 打了sp4后打开sqlmangr.exe和分析器都提示“不是有效的win32应用程序”
- 帮忙,哥你知道的
- 如何将网络上(A)机的SQL数据表下载到本地(B)上来
- sql server能否实现按日期累计产量的问题
- 一个字段的值能否通过其他表的某些字段通过一定的计算得到?
- 可以对存储过程返回的结果集进行二次查询吗?
- 请问数据库怎样用模糊查询查询同一张表里两个列,各位大佬帮帮忙
- 有没有比Access更好用的软件?
- sql server2005如何对特定用户设置只访问特定数据库
EXEC sp_configure 'Ad Hoc Distributed Queries'
RECONFIGURE
运行以后提示:the configuration option 'Ad Hoc Distributed Queries' does not exist,or it may be an advance option
还执行了'ad hoc remote queries',也是这个提示,是不是版本有问题?