{"id":1854,"date":"2024-07-16T17:32:11","date_gmt":"2024-07-16T09:32:11","guid":{"rendered":"http:\/\/www.jh1999.cn\/?p=1854"},"modified":"2025-01-07T14:44:16","modified_gmt":"2025-01-07T06:44:16","slug":"sql-server%e7%9a%84%e7%bb%b4%e6%8a%a4%e8%ae%a1%e5%88%92","status":"publish","type":"post","link":"http:\/\/www.jh1999.cn\/?p=1854","title":{"rendered":"\u7528\u6700\u4f4e\u6210\u672c\u5efa\u8bbe\u56fd\u9645\u7535\u5b50\u90ae\u5c40"},"content":{"rendered":"
\n\n

\u9996\u5148\u7533\u660e\uff0c\u672c\u6587\u4e0d\u662f\u4ecb\u7ecd\u7ffb\u5899\u7684SDWAN\uff01<\/p>\n\n\n\n

\u5efa\u8bbe\u548c\u7ba1\u7406\u4f01\u4e1a\u7535\u5b50\u90ae\u5c40\uff0c\u6700\u5927\u7684\u96be\u5ea6\u662f\u53cd\u5783\u573e\u90ae\u4ef6\uff0c\u800c\u6700\u5927\u7684\u56f0\u5883\u5219\u662f\u6536\u53d1\u6d77\u5916\u90ae\u4ef6\u7684\u4e0d\u7a33\u5b9a\u6027\uff0c\u9762\u5bf9\u56fd\u9645\u7f51\u7edc\u7684\u6ce2\u52a8\uff0c\u5e72\u7740\u6025\u3002\u672c\u6587\u4ee5\u5b9e\u4f8b\u6765\u4ecb\u7ecd\uff0c\u7528\u6700\u4f4e\u7684\u6210\u672c\u5efa\u8bbe\u4e00\u4e2a\u5e73\u7a33\u7684\u56fd\u9645\u6027\u7684\u7535\u5b50\u90ae\u5c40\u3002<\/p>\n\n\n\n

\u7279\u522b\u7684\u51c6\u5907\u5de5\u4f5c\uff1a<\/p>\n\n\n\n

    \n
  1. \u4e00\u6761\u6709\u56fa\u5b9a\u516c\u7f51IP\u7684\u4e0a\u7f51\u5bbd\u5e26\u3002\u5728\u6df1\u5733\uff0c\u8fd9\u79cd\u5bbd\u5e26\uff0c\u4e2d\u56fd\u79fb\u52a8500Mbps\u901f\u7387\u7684\u53ef\u4ee5\u505a\u5230\u4e00\u5343\u591a\u5757\u94b1\u6bcf\u5e74\u3002\u5b83\u9664\u4e86\u7ed9\u90ae\u4ef6\u670d\u52a1\u5668\u7528\uff0c\u8fd8\u53ef\u4ee5\u7ed9\u5c40\u57df\u7f51\u5185\u6240\u6709\u7535\u8111\u7528\u6765\u4e0a\u7f51\uff0c\u6240\u4ee5\u4e0d\u7b97\u589e\u52a0\u6210\u672c\u3002<\/li>\n\n\n\n
  2. \u4e00\u6761\u56fd\u9645\u7f51\u7edc\u4e13\u7ebf(\u4e0d\u8d70\u516c\u7f51\u90a3\u79cd)\uff0c\u4f8b\u5982MPLS\u3002\u672c\u5b9e\u4f8b\u662f\u6df1\u5733\u516c\u53f8\u4e0e\u9999\u6e2f\u603b\u90e8\u4e4b\u95f4\u7684MPLS\u4e13\u7ebf\u3002\u63d0\u4f9b\u8fd9\u79cd\u4e13\u7ebf\u7684ICP\u6709\u4e2d\u4fe1\u56fd\u9645\u7535\u8baf\uff0c\u9999\u6e2f\u7535\u8baf\u7b49\u7b49\uff0c\u4ef7\u683c\u4e0a\u6bd4\u4e2d\u56fd\u7535\u4fe1\u7684\u57ce\u57df\u7f51\u5bbd\u5e26\u8d35\u4e0d\u4e86\u591a\u5c11\u3002\u8fd9\u6761\u4e13\u7ebf\u9664\u4e86\u7ed9\u90ae\u4ef6\u670d\u52a1\u5668\u63d0\u4f9b\u7a33\u5b9a\u7684\u51fa\u53e3\u5e26\u5bbd\uff0c\u8fd8\u53ef\u4ee5\u5efa\u8bbeVOIP\uff0c\u8ba9\u56fd\u9645\u7535\u8bdd\u53d8\u6210\u5185\u7ebf\u7535\u8bdd\uff0c\u8fd8\u53ef\u4ee5\u505a\u7a33\u5b9a\u7684\u56fd\u9645\u89c6\u9891\u4f1a\u8bae\uff0c\u8fd8\u53ef\u4ee5\u8f7b\u677e\u5730\u4e0a\u56fd\u9645\u5b89\u89c4\u8ba4\u8bc1\u7f51\u7ad9\u7533\u62a5\u8d44\u6599\uff0c\u8fd8\u53ef\u4ee5\u505aVPN\uff0c\u8ba9\u6df1\u6e2f\u4e24\u5730\u529e\u516c\u5ba4\u91cc\u7684\u7535\u8111\u8c61\u5728\u540c\u4e00\u4e2a\u5c40\u57df\u7f51\u91cc\u4e00\u6837\u4fbf\u6377\u8bbf\u95ee\uff0c\u7b49\u7b49\u3002\u8fd9\u662f\u672c\u65b9\u6848\u552f\u4e00\u8981\u589e\u52a0\u7684\u6210\u672c\uff0c\u4f46\u6536\u76ca\u4e5f\u5f88\u5927\u3002<\/li>\n\n\n\n
  3. MX\u89e3\u6790\u505a\u4e24\u4e2a\uff0c\u56fd\u5185\u548c\u6d77\u5916\u3002\u5927\u90e8\u4efd\u4e92\u8054\u7f51\u5185\u5bb9\u670d\u52a1\u5546\u80fd\u63d0\u4f9b\u8fd9\u79cd\u89e3\u6790\u670d\u52a1\uff0c\u5982\u679c\u60a8\u7684\u57df\u540d\u4e0d\u597d\u5f69\uff0c\u662f\u5728\u67d0\u58f3\u6ce8\u518c\u7684\uff0c\u8fd8\u5f97\u53bb\u5176\u5b83\u7684ICP\u6ce8\u518c\u4e00\u4e2aMX\u4e3b\u673a\u540d\uff0c\u628a\u90ae\u7bb1\u57df\u540d\u7684MX\u8bb0\u5f55\u6307\u5411\u65b0\u6ce8\u518c\u7684MX\u4e3b\u673a\u540d\u3002\u9a8c\u8bc1\u7ed3\u679c\u5982\u4e0b(\u5316\u540d\u4e3e\u4f8b)\uff1a<\/li>\n<\/ol>\n\n\n\n
    C:\\>nslookup xmail.jh1999.cn 8.8.8.8\n\u4f3a\u670d\u5668:  dns.google\nAddress:  8.8.8.8\nDNS request timed out.\n    timeout was 2 seconds.\n\u672a\u7d93\u6388\u6b0a\u7684\u56de\u7b54:\n\u540d\u7a31:    xmail.jh1999.cn\nAddress:  203.85.32.2\n\nC:\\>nslookup xmail.jh1999.cn 114.114.114.114\n\u4f3a\u670d\u5668:  public1.114dns.com\nAddress:  114.114.114.114\n\u672a\u7d93\u6388\u6b0a\u7684\u56de\u7b54:\n\u540d\u7a31:    xmail.jh1999.cn\nAddress:  119.145.3.8<\/code><\/pre>\n\n\n\n
    \u7f51\u7edc\u62d3\u4ec6\u56fe<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \u56fd\u5185\u9632\u706b\u5899(\u4ee5\u534e\u4e3aUSG6300\u4e3a\u4f8b)\u914d\u7f6e\uff1a<\/p>\n\n\n\n
      \n
    1. \u7f51\u7edc \u2192 \u63a5\u53e3 \u2192 LAN\u63a5\u53e3(192.168.0.4)\uff1a\u8981\u52fe\u9009\u201c\u591a\u51fa\u53e3\u9009\u9879\u201d\u548c\u201c\u6e90\u8fdb\u6e90\u51fa\u8def\u7531\u63a7\u5236\u201d\uff0c\u4f46\u4e0d\u8981\u52fe\u201c\u7f3a\u7701\u8def\u7531\u201d\uff0c\u9ed8\u8ba4\u7f51\u5173\u586bMPLS\u672c\u7aef\u8def\u7531\u5668\u7684\u5185\u7f51IP\u5730\u5740\u3002<\/li>\n\n\n\n
    2. \u7f51\u7edc \u2192 \u63a5\u53e3 \u2192 WAN\u63a5\u53e3(119.145.3.8)\uff1a\u8981\u52fe\u9009\u201c\u591a\u51fa\u53e3\u9009\u9879\u201d\u548c\u201c\u6e90\u8fdb\u6e90\u51fa\u8def\u7531\u63a7\u5236\u201d\uff0c\u8fd8\u8981\u52fe\u201c\u7f3a\u7701\u8def\u7531\u201d\uff0c\u9ed8\u8ba4\u7f51\u5173\u586bICP\u4f9b\u5e94\u5546\u63d0\u4f9b\u7684\u7f51\u5173IP\uff0cDNS\u670d\u52a1\u5668\u5efa\u8bae\u7528223.5.5.5\uff0c\u81ea2024\u5e746\u6708\u4efd\u540e114.114.114.114DNS\u89e3\u6790\u6d77\u5916\u5730\u5740\u6709\u65f6\u5f02\u5e38\u3002<\/li>\n\n\n\n
    3. \u7b56\u7565 \u2192 NAT\u7b56\u7565 \u2192 \u6e90NAT\uff1a\u589e\u52a0\u8bb0\u5f55(NAT4-9)\uff0ctrust\u2192trust\uff0c\u670d\u52a1=smtp\uff0c\u8f6c\u6362\u65b9\u5f0f=\u4e0d\u505aNAT\u8f6c\u6362(\u5bf9\u65b9\u53ef\u89c1\u5230\u6e90IP\uff0c\u4ee5\u514d\u8bef\u5224)\uff0c\u5176\u5b83\u90fd\u9009any\u3002<\/li>\n\n\n\n
    4. \u7b56\u7565 \u2192 NAT\u7b56\u7565 \u2192 \u6e90NAT \u2192 NAT\u5730\u5740\u6c60\uff1a\u589e\u52a0\u8bb0\u5f55(Addr3.8)\uff0cIP\u5730\u5740\u8303\u56f4=119.145.3.8\uff0c\u52fe\u9009\u201c\u5145\u8bb8\u7aef\u53e3\u5730\u5740\u8f6c\u6362\u201d\uff0c\u5176\u5b83\u4fdd\u6301\u9ed8\u8ba4\u503c\u3002<\/li>\n\n\n\n
    5. \u7b56\u7565 \u2192 NAT\u7b56\u7565 \u2192 \u6e90NAT\uff1a\u589e\u52a0\u8bb0\u5f55(NAT3.8)\uff0ctrust\u2192untrust\uff0c\u670d\u52a1=any\uff0c\u8f6c\u6362\u65b9\u5f0f=\u5730\u5740\u6c60\u4e2d\u7684\u5730\u5740\uff0c\u5730\u5740\u6c60=Addr3.8\uff0c\u5176\u5b83\u90fd\u9009any\u3002<\/li>\n\n\n\n
    6. \u7b56\u7565 \u2192 NAT\u7b56\u7565 \u2192 \u670d\u52a1\u5668\u6620\u5c04\uff1a\u589e\u52a0\u8bb0\u5f55(SMTP-HK)\uff0c\u516c\u7f51\u5730\u5740=192.168.0.4\uff0c\u79c1\u7f51\u5730\u5740=192.168.0.9\uff0c\u534f\u8bae=TCP\uff0c\u516c\u7f51\u7aef\u53e3=25\uff0c\u79c1\u7f51\u7aef\u53e3=25\u3002<\/li>\n\n\n\n
    7. \u7b56\u7565 \u2192 NAT\u7b56\u7565 \u2192 \u670d\u52a1\u5668\u6620\u5c04\uff1a\u589e\u52a0\u8bb0\u5f55(SMTP-CN)\uff0c\u516c\u7f51\u5730\u5740=119.145.3.8\uff0c\u79c1\u7f51\u5730\u5740=192.168.0.9\uff0c\u534f\u8bae=TCP\uff0c\u516c\u7f51\u7aef\u53e3=25\uff0c\u79c1\u7f51\u7aef\u53e3=25\u3002<\/li>\n<\/ol>\n\n\n\n
      \u9999\u6e2f\u9632\u706b\u5899(\u4ee5SonicWall\u4e3a\u4f8b)\u914d\u7f6e\uff1a\u5173\u952e\u4e00\u70b9\u662f\uff0c\u628aWAN\u53e3203.85.32.2\u768425\u7aef\u53e3\u6620\u5c04\u5230\u6df1\u5733\u9632\u706b\u5899LAN\u53e3192.168.0.4\u768425\u7aef\u53e3\u3002<\/p>\n\n\n\n
      \u901a\u8fc7\u4e0a\u8ff0\u7ec4\u5408\u62f3\uff0c\u6d77\u5916\u6765\u7684\u90ae\u4ef6\u901a\u8fc7\u4e13\u7ebf\u8fdb\u5165\u670d\u52a1\u5668\uff0c\u56fd\u5185\u6765\u7684\u90ae\u4ef6\u5219\u901a\u8fc7\u4e0a\u7f51\u5bbd\u5e26\u8fdb\u5165\u670d\u52a1\u5668\u3002\u53d1\u5f80\u6d77\u5916\u7684\u90ae\u4ef6\uff0c\u6dfb\u52a0\u76f8\u5e94\u7684\u9759\u6001\u8def\u7531\uff0c\u8ba9\u5176\u901a\u8fc7\u4e13\u7ebf\u79bb\u5883\uff0c\u53d1\u5f80\u56fd\u5185\u7684\u90ae\u4ef6\u8ba9\u5176\u8d70\u9ed8\u8ba4\u8def\u5f84\u5373\u53ef\u3002\u5982\u6b64\uff0c\u6536\u53d1\u90ae\u4ef6\u90fd\u907f\u5f00\u4e86\u56fd\u9645\u516c\u5171\u7f51\u7edc\u7684\u6ce2\u52a8\uff0c\u7a33\u7a33\u7684\u4e00\u53f0\u56fd\u9645\u7535\u5b50\u90ae\u5c40\u5efa\u6210\uff01<\/p>\n\n\n\n
      \u5f53\u7136\uff0c\u5982\u679c\u90ae\u5c40\u91cc\u7684\u90ae\u7bb1\u4e0d\u5230\u4e00\u767e\u4e2a\uff0c\u5411ICP\u79df\u7528\u4f01\u4e1a\u90ae\u5c40\uff0c\u5728\u91d1\u989d\u4e0a\u4f1a\u66f4\u52a0\u5b9e\u60e0\u3002<\/p>\n\n\n\n
      \u6ce8\u610f\u4e8b\u9879\uff1a<\/p>\n\n\n\n
        \n
      1. \u90ae\u4ef6\u670d\u52a1\u5668192.168.0.9\u7684\u8def\u7531\u8868\u8981\u5e72\u51c0\uff0c\u5404\u79cd\u7b56\u7565\u8def\u7531\u7ebf\u8def\u5c3d\u91cf\u5728\u7f51\u5173\u4e2d\u5b9e\u73b0\u3002<\/li>\n\n\n\n
      2. \u5e38\u7528\u7684\u6d77\u5916SMTP\u63a5\u6536\u670d\u52a1\u5668IP\uff0c\u53ef\u4ee5\u5728\u90ae\u4ef6\u670d\u52a1\u5668\u91cc\u52a0\u9759\u6001\u8def\u7531\uff0c\u7ecfMPLS\u9999\u6e2f\u9632\u706b\u5899\u94fe\u63a5\u3002<\/li>\n\n\n\n
      3. \u82e5\u6d77\u5916\u7684\u63a5\u6536\u670d\u52a1\u5668\u540c\u65f6\u517c\u505a\u53d1\u9001\u670d\u52a1\u5668\uff0c\u4e0d\u53ef\u7ecfMPLS\u5efa\u8def\u7531\uff0c\u547c\u53eb\u548c\u53cd\u5e94\u5fc5\u987b\u7ebf\u8def\u4e00\u81f4\u624d\u80fd\u5b8c\u6210\u4f1a\u8bdd\u3002<\/li>\n\n\n\n
      4. \u4e0e\u90ae\u4ef6\u670d\u52a1\u5668\u540c\u5c5e\u4e00\u7f51\u6bb5(192.168.0.0\/24)\u7684\u7535\u8111\uff0ctelnet 192.168.0.4  25 \u4f1a\u5931\u8d25\uff0c\u8fd9\u4e0d\u5f71\u54cd\u90ae\u4ef6\u6536\u53d1\u3002<\/li>\n<\/ol>\n\n\n
        \n
        \"\"<\/figure>\n<\/div>\n
        <\/svg><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"
        \u9996\u5148\u7533\u660e\uff0c\u672c\u6587\u4e0d\u662f\u4ecb\u7ecd\u7ffb\u5899\u7684SDWAN\uff01 \u5efa\u8bbe\u548c\u7ba1\u7406\u4f01\u4e1a\u7535\u5b50\u90ae\u5c40\uff0c\u6700\u5927\u7684\u96be\u5ea6\u662f\u53cd\u5783\u573e\u90ae\u4ef6\uff0c\u800c\u6700\u5927\u7684\u56f0\u5883\u5219\u662f\u6536\u53d1 … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1854","post","type-post","status-publish","format-standard","hentry","category-kfbj"],"_links":{"self":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/1854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1854"}],"version-history":[{"count":41,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/1854\/revisions"}],"predecessor-version":[{"id":2487,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/1854\/revisions\/2487"}],"wp:attachment":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1854"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}