{"id":14557,"date":"2017-02-02T05:00:00","date_gmt":"2017-02-01T21:00:00","guid":{"rendered":"http:\/\/blog.pmail.idv.tw\/?p=14557"},"modified":"2024-05-12T08:51:02","modified_gmt":"2024-05-12T00:51:02","slug":"system-centr-configuration-manager-2012-r2-sp1%e4%bd%88%e7%bd%b2lab-2sql-server-%e6%ba%96%e5%82%99","status":"publish","type":"post","link":"https:\/\/blog.pmail.idv.tw\/?p=14557","title":{"rendered":"System Centr Configuration Manager 2012 R2 SP1\u4f48\u7f72LAB (2)&ndash;SQL Server \u6e96\u5099"},"content":{"rendered":"<p>\u524d\u8a00:<\/p>\n<p>AD Container \u53ca\u64f4\u5145Active Directory Schema \u76f8\u95dc\u8a2d\u5b9a\u5b8c\u6210\u5f8c\uff0c\u63a5\u8457\u5c31\u662f\u6e96\u5099\u4e00\u53f0SQL \uff0c\u7576\u7136SQL \u53ef\u4ee5\u8207SCCM \u4e3b\u6a5f\u5b89\u88dd\u5728\u540c\u4e00\u53f0\u4e3b\u6a5f\uff0c\u4f46\u662f\u500b\u4eba\u5efa\u8b70\u5c07SQL\u8207SCCM\u4e3b\u6a5f\u5206\u958b\u6bd4\u8f03\u597d\u3002<\/p>\n<p><!--more--><\/p>\n<p>\u672c\u6b21\u7df4\u7fd2\u74b0\u5883\u4f7f\u7528\u7684\u662f<strong>SQL&nbsp; Server 2012&nbsp; sp3 \u6a19\u6e96\u7248<\/strong> \uff0c\u5b89\u88dd\u904e\u7a0b\u5c31\u4e0d\u5728\u8a73\u7d30\u8aaa\u660e\uff0c\u53ea\u8a18\u9304\u6ce8\u610f\u4e8b\u9805\u3002<\/p>\n<p>SQL \u529f\u80fd\u53ea\u9700\u5b89\u88dd =&gt; Database Engine Services\u3001Reporting Services\u3001\u7ba1\u7406\u5de5\u5177  <\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/clip_image001.png\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image001\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"clip_image001\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/clip_image001_thumb.png\" width=\"559\" height=\"543\"><\/a>  <\/p>\n<p>\u5b9a\u5e8f\u8acb\u9078\u64c7 :<strong> SQL_Latin1_General_CP1_CI_AS<\/strong>  <\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/image.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/image_thumb.png\" width=\"644\" height=\"339\"><\/a><\/p>\n<p>SQL \u76f8\u95dc\u670d\u52d9\u5fae\u8edf\u5efa\u7acb\u4f7f\u7528\u500b\u5225\u5e33\u6236\uff0c\u6b64\u7df4\u7fd2\u4f7f\u7528\u7684\u5f0fdomain user account&nbsp; =&gt; scadmin<a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/image1.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/image_thumb1.png\" width=\"644\" height=\"380\"><\/a><\/p>\n<p>SQL \u8a18\u61b6\u9ad4\u8a2d\u5b9a:<\/p>\n<p>\u56e0\u91dd\u5c0d\u7ba1\u7406\u4e2d\u5fc3\u7db2\u7ad9\u548c\u4e3b\u8981\u7ad9\u53f0\uff0cConfiguration Manager \u9700\u8981 SQL Server \u5728 SQL Server \u57f7\u884c\u500b\u9ad4\u6240\u4f7f\u7528\u7684\u7de9\u885d\u96c6\u5340\u4e2d\u4fdd\u7559\u6700\u5c11 8 GB \u7684\u8a18\u61b6\u9ad4\uff0c\u91dd\u5c0d\u6b21\u8981\u7ad9\u53f0\u4fdd\u7559\u6700\u5c11 4 GB\u3002<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/SCCM-29.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" title=\"SCCM-29\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"SCCM-29\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2017\/02\/SCCM-29_thumb.png\" width=\"644\" height=\"285\"><\/a><\/p>\n<div class=\"21cd169d3c0f71e95b84db320302cb4a\" data-index=\"1\" style=\"float: right; margin:10px 0 10px 10px;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8711325745898650\"\r\n     crossorigin=\"anonymous\"><\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u524d\u8a00: AD Container \u53ca\u64f4\u5145Active Directory Sch &hellip; <a href=\"https:\/\/blog.pmail.idv.tw\/?p=14557\">\u95b1\u8b80\u5168\u6587 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[144],"tags":[],"class_list":["post-14557","post","type-post","status-publish","format-standard","hentry","category-sccm2012r2"],"_links":{"self":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/14557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14557"}],"version-history":[{"count":1,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/14557\/revisions"}],"predecessor-version":[{"id":20281,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/14557\/revisions\/20281"}],"wp:attachment":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}