SQLServer阻止了對(duì)組件(AdHocDistributedQueries)的訪問(wèn)錯(cuò)誤

想用openrowset查詢遠(yuǎn)程數(shù)據(jù)庫(kù)，結(jié)果提示SQL Server 阻止了對(duì)組件 \'Ad Hoc Distributed Queries\' 的訪問(wèn)錯(cuò)誤，在網(wǎng)上搜索了一下，找到解決方法：
    啟用Ad Hoc Distributed Queries：
    exec sp_configure 'show advanced options',1
    reconfigure
    exec sp_configure 'Ad Hoc Distributed Queries',1
    reconfigure
    Examda提示:使用完成后，關(guān)閉Ad Hoc Distributed Queries：
    exec sp_configure 'Ad Hoc Distributed Queries',0
    reconfigure
    exec sp_configure 'show advanced options',0
    reconfigure
    SELECT *
    FROM OPENDATASOURCE(
    'SQLOLEDB',
    'Data Source=ServerName;User ID=sa;Password=sa'
    ).DataBaseName.dbo.Table
    select * from openrowset( 'SQLOLEDB ', 'IP地址'; '用戶名'; '密碼',數(shù)據(jù)庫(kù)名.dbo.表名)