Unit one today ASP.NET Website , There is a function to export data , Report an error as soon as you find it , What is the content of the error report :SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The interview of , Because this component has been shut down as part of this server's security configuration . System administrators can use the sp_configure Enable 'Ad Hoc Distributed Queries'. About enabling 'Ad Hoc Distributed Queries' Details of , see also SQL Server In Books Online " Peripheral Configurator ".

If you look at the error prompt, you know it's because SQL Server Of Ad Hoc Distributed Queries Component is disabled , I used it here SQL Server The version is 2005, Just turn on Ad Hoc Distributed Queries That's all right. , The method is as follows :

1. Turn on Ad Hoc Distributed Queries Components , stay sql Execute the following statement in the query editor :

exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

2. close Ad Hoc Distributed Queries Components , stay sql Execute the following statement in the query editor :

exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure

SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT 'OpenRowset/OpenDatasource' The interview of , Because this component has been shut down as part of this server's security configuration . System administrators can use the sp_configure Enable 'Ad Hoc Distributed Queries'. More articles about

  1. SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The interview of

    delphi ado Cross database access The statement is as follows ' and db = ' A set of books 1' What is the content of the error report :SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATE ...

  2. SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT 'OpenRowset/OpenDatasource' The interview of

    news 15281, Level 16, state 1, The first 2 That's ok SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT 'OpenRowset/Open ...

  3. Sql Export data error -->SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The interview of

    SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The interview of , Because this component is already used as this service ...

  4. [ original ]SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT 'OpenRowset/OpenDatasource' The interview of

    TSQL Inquire about Excel Data usage openrowset The following errors are usually reported : news , Level , state , The first That's ok SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of ...

  5. About “SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The interview of ”

    reason : Appears when copying data from a remote server to a local server “SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatas ...

  6. SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The solution to access

    I wrote one today excel Table import function , It turns out that excel An error occurs when the content in the table is imported into the page :SQL  Server Blocking of components 'Ad Hoc Distributed Queries' Of   STATEMENT ...

  7. solve SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT 'OpenRowset/OpenDatasource' The interview of

    Proceed as needed asp.net Data import and export , The result is the following error : mark-1: [ Report errors ]SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT ...

  8. solve “SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT 'OpenRowset/OpenDatasource' The interview of ……”【 turn 】

    SQL Server Blocking of components /'Ad Hoc Distributed Queries/' The interview of stay Sql Server Check it out Excel There was a problem with the file : SELECT *  FROM ...

  9. SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATEMENT'OpenRowset/OpenDatasource' The interview of ( That is, cross database access error )

    delphi ado Cross database access The statement is as follows ' and db = ' A set of books 1' What is the content of the error report :SQL Server Blocking of components 'Ad Hoc Distributed Queries' Of STATE ...

Random recommendation

  1. ie7 Next <a href="javascript:;"> The label doesn't react

    <a  href="javascript:;" onclick="functionOne()"> Click on </a> <script&g ...

  2. max10 Chinese vs DDR Data sampling and conversion

    (1) Find out IP This is how it is handled DDR The data of : The data collected along the upper length is put in the lower position , The data of falling edge mining is in high position (2) The line field signal of video is collected on the falling edge , One more beat to align with the data .

  3. algorithm The invariant sequence operation of

    summary : Invariant sequence algorithm , See http://www.cplusplus.com/reference/algorithm/ /* std::for_each template <class InputI ...

  4. Inside the cluster Session The implementation principle of high availability

    In this era of highly developed Internet , Many applications have millions of users , Even hundreds of millions . In order to support massive user access , Application server cluster is the most common way to expand horizontally . In this case , It will involve a lot of problems that don't need to be considered in a stand-alone environment , Among them ...

  5. 【 turn 】Java And C# Language level comparison

    Link to the original text :http://www.harding.edu/fmccown/java_csharp_comparison.html Java Program structure C# package hello;public cl ...

  6. iOS of use UILabel Realization UITextView The space occupying words of

    @interface BSPublishTextView : UITextView /** External attribute space occupying characters placeholder */ @property (nonatomic, copy) NS ...

  7. vmware Virtual machine error reporting Delete folder , Can recover

  8. The latest Alibaba cloud application is free SSL Certificate implementation website HTTPS turn ( Picture and text course 1 )

    One . Apply for free SSL certificate : 1. Log in to alicloud : 2. Get the voucher package : https://promotion.aliyun.com/ntms/yunparter/invite.html?userCode=0a ...

  9. python subprocess Module details

    One .subprocess Standard library python perform shell Script , You usually use so Several methods in the module , Such as system.spawn*.popen etc. .subprocess The introduction of the standard library is to replace these old modular methods ...

  10. Android- SharedPreferences The use of,

    Android-SharedPreferences The use of, Reference resources https://developer.android.google.cn/reference/android/content/Shar ...