{"id":204,"date":"2011-08-03T16:07:11","date_gmt":"2011-08-03T08:07:11","guid":{"rendered":"http:\/\/blog.nami.idv.tw\/?p=204"},"modified":"2019-07-12T13:53:10","modified_gmt":"2019-07-12T05:53:10","slug":"%e5%a6%82%e4%bd%95%e6%8c%87%e5%ae%9a%e4%bb%a5-shared-memory-%e6%96%b9%e5%bc%8f%e9%80%a3%e7%b7%9a%e5%88%b0-mssql-server","status":"publish","type":"post","link":"https:\/\/blog.nami.idv.tw\/?p=204","title":{"rendered":"\u5982\u4f55\u6307\u5b9a\u4ee5 Shared memory \u65b9\u5f0f\u9023\u7dda\u5230 MSSQL Server"},"content":{"rendered":"<p>\u689d\u4ef6\u5982\u4e0b\uff1a<\/p>\n<ol>\n<li>\u76ee\u6a19 Microsoft SQL Server instance \u8981\u5728\u672c\u6a5f(localhost)<\/li>\n<li>Provider \u8981\u8ddf\u76ee\u6a19\u7248\u672c\u4e00\u81f4:\n<ol>\n<li>SQLOLEDB : Microsoft SQL Server 2000<\/li>\n<li>SQLNCLI : Microsoft SQL Server 2005<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms131321.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">SQLNCLI<\/a> : Microsoft SQL Server 2008<\/li>\n<\/ol>\n<\/li>\n<li>Connection string \u7684 Data source \u8a2d\u5b9a\u6210 <strong>lpc:<\/strong><\/li>\n<\/ol>\n<p><!--more-->\u5982\u679c\u8981\u7528 TCP\/IP \u9023\u7dda\u7684\u8a71\u5247\u662f\uff1a<\/p>\n<ol>\n<li>\u76ee\u6a19 Microsoft SQL Server instance \u8981\u9023\u7684\u5230<\/li>\n<li>Provider \u76e1\u91cf\u8ddf\u76ee\u6a19\u7248\u672c\u4e00\u81f4:\n<ol>\n<li>SQLOLEDB : Microsoft SQL Server 2000<\/li>\n<li>SQLNCLI : Microsoft SQL Server 2005<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms131321.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">SQLNCLI<\/a> : Microsoft SQL Server 2008<\/li>\n<\/ol>\n<\/li>\n<li>Connection string \u7684 Data source \u8a2d\u5b9a\u6210 <strong>LOCALHOST<\/strong> \u6216<strong> IP Address<\/strong> \u6216<strong> HOST NAME<\/strong><\/li>\n<li>\u5982\u679c Port \u4e0d\u4f7f\u7528\u662f\u9810\u8a2d\u7684 1433\uff0c\u90a3\u8acb\u52a0\u4e0a [,PORT NUMBER]\uff0c\u4f8b\u5982: Data Source = LOCALHOST,1433<\/li>\n<\/ol>\n<p>Connection string \u53c3\u8003\uff1a<\/p>\n<pre class=\"brush: plain; ruler: true;\">Windows \u6574\u5408\u578b\u8a8d\u8b49:\nProvider=SQLNCLI;Data Source=lpc:;Initial Catalog=some_db;Integrated Security=SSPI;\nProvider=SQLNCLI;Data Source=LOCALHOST,1433;Initial Catalog=some_db;Integrated Security=SSPI;\n\nSQL Server \u8a8d\u8b49:\nProvider=SQLNCLI;Data Source=lpc:;User ID=sara;Password=iDuNnO;Initial Catalog=some_db;\nProvider=SQLNCLI;Data Source=LOCALHOST,1433;User ID=sara;Password=iDuNnO;Initial Catalog=some_db;<\/pre>\n<p><span class=\"st\">\u81f3\u65bc\u70ba\u4ec0\u9ebc\u6703\u60f3\u5230\u7814\u7a76\u9019\u500b<\/span>\uff1f\u8acb\u770b\u4e0b\u5716\uff1a<\/p>\n<p><a href=\"https:\/\/blog.nami.idv.tw\/wp-content\/uploads\/2011\/08\/connection_burst_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-205\" title=\"connection_burst_2\" src=\"https:\/\/blog.nami.idv.tw\/wp-content\/uploads\/2011\/08\/connection_burst_2.png\" alt=\"\" width=\"774\" height=\"770\" srcset=\"https:\/\/blog.nami.idv.tw\/wp-content\/uploads\/2011\/08\/connection_burst_2.png 774w, https:\/\/blog.nami.idv.tw\/wp-content\/uploads\/2011\/08\/connection_burst_2-150x150.png 150w, https:\/\/blog.nami.idv.tw\/wp-content\/uploads\/2011\/08\/connection_burst_2-300x298.png 300w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/a><\/p>\n<p>\u5354\u52a9\u5ba2\u6236\u9077\u79fb\u5ba2\u6236\u4e4b\u524d\u59d4\u8a17\u5176\u4ed6\u5ee0\u5546\u958b\u767c\u7684\u7cfb\u7d71\uff0c\u9077\u79fb\u5230\u65b0\u4e3b\u6a5f\u5f8c\u4f7f\u7528\u8005\u53cd\u6620\u5f88\u6162\uff0c\u767b\u5165\u4e0d\u80fd\u4e14\u5831\u8868\u6309\u4e0b\u53bb\u534a\u5929\u6c92\u51fa\u4f86\u9084\u6709\u932f\u8aa4\u8a0a\u606f\uff0c\u7d50\u679c\u4e00\u8ffd\u8336\u5305\u5f8c\u767c\u73fe\uff0c\u4e00\u96bb\u5831\u8868\u7522\u751f\u7a0b\u5f0f\u6309\u4e0b\u53bb\u5f8c\u7684\u9023\u7dda\u6578\u662f\u9019\u6a23\u2027\u2027\u2027(\u986f\u793a\u70ba\u7cfb\u7d71\u5c0d\u8cc7\u6599\u5eab\u767c\u52d5 DoS Attack \u72c0\u614b)<\/p>\n<p>\u7a0b\u5f0f\u8a2d\u8a08\u771f\u7684\u4eba\u5916\u6709\u4eba\u5929\u5916\u6709\u5929\u554a\uff5e\uff08\u8336\uff09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u689d\u4ef6\u5982\u4e0b\uff1a \u76ee\u6a19 Microsoft SQL Server instance \u8981 &hellip; <a href=\"https:\/\/blog.nami.idv.tw\/?p=204\">\u95b1\u8b80\u5168\u6587 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[33],"tags":[18],"class_list":["post-204","post","type-post","status-publish","format-standard","hentry","category-develop","tag-mssql"],"_links":{"self":[{"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=204"}],"version-history":[{"count":5,"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/204\/revisions"}],"predecessor-version":[{"id":719,"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/204\/revisions\/719"}],"wp:attachment":[{"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nami.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}