{"id":1926,"date":"2019-12-09T13:26:43","date_gmt":"2019-12-09T05:26:43","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=1926"},"modified":"2019-12-09T13:27:19","modified_gmt":"2019-12-09T05:27:19","slug":"sql-ad-hoc-distributed","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2019\/12\/09\/sql-ad-hoc-distributed\/","title":{"rendered":"SQL Server \u5df2\u5c01\u9396\u5143\u4ef6 &#8216;Ad Hoc Distributed Queries&#8217; \u7684 STATEMENT &#8216;OpenRowset\/OpenDatasource&#8217; \u4e4b\u5b58\u53d6&#8230;..\u8b66\u544a\u8a0a\u606f"},"content":{"rendered":"<p>\u5c0f\u7de8\u5728\u4e00\u500b\u5c07SQL 2000 Server\u66ff\u63db\u6210SQL 2008R2 Express\u7684\u6848\u4f8b\u4e0a\uff0c\u9047\u5230\u4e86\u300cSQL Server \u5df2\u5c01\u9396\u5143\u4ef6 &#8216;Ad Hoc Distributed Queries&#8217; \u7684 STATEMENT &#8216;OpenRowset\/OpenDatasource&#8217; \u4e4b\u5b58\u53d6<!--more-->\uff0c\u56e0\u70ba\u6b64\u5143\u4ef6\u5df2\u7d93\u7531\u6b64\u4f3a\u670d\u5668\u7684\u5b89\u5168\u6027\u7d44\u614b\u95dc\u9589\u3002\u7cfb\u7d71\u7ba1\u7406\u54e1\u53ef\u4ee5\u4f7f\u7528 sp_configure \u4f86\u555f\u7528 &#8216;Ad Hoc Distributed Queries&#8217; \u7684\u4f7f\u7528\u3002\u5982\u9700\u6709\u95dc\u555f\u7528 &#8216;Ad Hoc Distributed Queries&#8217; \u7684\u8a73\u7d30\u8cc7\u8a0a\uff0c\u8acb\u53c3\u95b1\u300aSQL Server \u7dda\u4e0a\u53e2\u66f8\u300b\u4e2d\u7684\uff1c\u4ecb\u9762\u5340\u7d44\u614b\uff1e(Surface Area Configuration)\u3002\u300d<\/p>\n<p>\u9019\u500b\u767c\u751f\u7684\u539f\u56e0\u662fSQL 2008R2\u628aFacet\u7684\u4ecb\u9762\u5340\u7d44\u614b\u4e2d\u7684\u300cAdHocRemoteQueriesEnable\u300d\u53ca\u300cXPcmdShellEnabled\u300d\u6539\u70ba\u9810\u8a2d\u95dc\u9589\u4e86\uff0c\u56e0\u6b64\u53ea\u8981\u4f9d\u64da\u72c0\u6cc1\u555f\u52d5\u9019\u5169\u500b\u529f\u80fd\u5373\u53ef\u6392\u9664\u3002<\/p>\n<p>\u900f\u904eSQL Server Management Studio\u9023\u7dda\u8cc7\u6599\u5eab\u5f8c\uff0c\u5728\u300c\u7269\u4ef6\u7e3d\u7ba1\u300d\u6700\u4e0a\u65b9\u9ede\u9078\u6ed1\u9f20\u53f3\u9375\uff0c\u63a5\u8457\u9078\u64c7\u300cFacet(A)\u300d<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1928\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2019\/12\/sql2k801.png\" alt=\"\" width=\"592\" height=\"444\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2019\/12\/sql2k801.png 592w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2019\/12\/sql2k801-300x225.png 300w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/p>\n<p>Facet(F)\u9078\u64c7\u300c\u4ecb\u9762\u5340\u7d44\u614b\u300d\uff0c\u63a5\u8457\u5728Facet\u5c6c\u6027(P)\u5217\u8868\u4e2d\u5c07\u300cAdHocRemoteQueriesEnable\u300d\u53ca\u300cXPcmdShellEnabled\u300d\u6539\u70ba\u300cTrue\u300d<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1929 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2019\/12\/sql2k802.png\" alt=\"\" width=\"722\" height=\"346\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2019\/12\/sql2k802.png 722w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2019\/12\/sql2k802-300x144.png 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c0f\u7de8\u5728\u4e00\u500b\u5c07SQL 2000 Server\u66ff\u63db\u6210SQL 2008R2 Express\u7684\u6848\u4f8b\u4e0a\uff0c\u9047\u5230\u4e86\u300cSQL  &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ailog.tw\/lifelog\/2019\/12\/09\/sql-ad-hoc-distributed\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008SQL Server \u5df2\u5c01\u9396\u5143\u4ef6 &#8216;Ad Hoc Distributed Queries&#8217; \u7684 STATEMENT &#8216;OpenRowset\/OpenDatasource&#8217; \u4e4b\u5b58\u53d6&#8230;..\u8b66\u544a\u8a0a\u606f\u3009<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1930,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,387,386],"tags":[401,668,666,559,669,667],"class_list":["post-1926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itinfo","category-database","category-windows","tag-2008r2","tag-ad-hoc-distributed-queries","tag-adhocremotequeriesenable","tag-sql","tag-sql-server-","tag-xpcmdshellenabled"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/1926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/comments?post=1926"}],"version-history":[{"count":3,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/1926\/revisions"}],"predecessor-version":[{"id":1932,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/1926\/revisions\/1932"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media\/1930"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=1926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=1926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=1926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}