{"id":1793,"date":"2011-07-06T00:37:49","date_gmt":"2011-07-06T00:37:49","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1793"},"modified":"2011-07-20T00:45:23","modified_gmt":"2011-07-20T00:45:23","slug":"sql-server2005-%e8%87%aa%e5%8a%a8%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2011\/07\/06\/sql-server2005-%e8%87%aa%e5%8a%a8%e5%ae%89%e8%a3%85\/","title":{"rendered":"SQL SERVER2005 \u81ea\u52a8\u5b89\u88c5"},"content":{"rendered":"<p> \u53c2\u8003\uff1ahttp:\/\/technet.microsoft.com\/zh-cn\/library\/ms144259(SQL.90).aspx<br \/>\n\u8fd0\u884c\uff1astart \/wait setup.exe \/qb \/settings setup.ini \uff08\u6ce8\uff1asetup.exe\u6700\u597d\u662fSQL Server x86\\Servers\u4e0b\u7684\uff09<br \/>\nstart \/wait :dos\u547d\u4ee4\uff0c\u542f\u52a8\u5e94\u7528\u7a0b\u5e8f\u5e76\u7b49\u5f85\u5b83\u7ed3\u675f\u3002<br \/>\nsetup.ini\u53ef\u53c2\u8003\\SQL Server x86\\Servers\u4e0b\u7684template.ini\u6587\u4ef6<br \/>\n\u6ce8\uff1a\u5176\u4e2d\u7684\/qb\u8868\u793a\u53ef\u770b\u89c1\u5b89\u88c5\u753b\u9762\uff0c\u82e5\u6539\u4e3a\/qn\u5219\u5b8c\u5168\u5728\u540e\u53f0\u8fd0\u884c\u5b89\u88c5<br \/>\nsetup.ini\u914d\u7f6e:<br \/>\n[Options]<br \/>\nUSERNAME=user<br \/>\nCOMPANYNAME=lvshou<br \/>\nPIDKEY=B4H74BJX3P37RX2J9TTBH9RMJ<br \/>\nINSTALLSQLDIR=&#8221;C:\\Program Files\\Microsoft SQL Server\\&#8221;<br \/>\nINSTALLOLAPDATADIR=&#8221;C:\\Program Files\\Microsoft SQL Server\\MSSQL\\OLAP\\Data&#8221;<br \/>\nADDLOCAL=All<br \/>\nINSTANCENAME=MSSQLSERVER<br \/>\nSECURITYMODE=SQL<br \/>\nSAPWD=LifeIsGood<br \/>\nSQLACCOUNT=NT AUTHORITY\\SYSTEM<br \/>\nAGTACCOUNT=NT AUTHORITY\\SYSTEM<br \/>\nSQLBROWSERACCOUNT=NT AUTHORITY\\SYSTEM<br \/>\nASACCOUNT=NT AUTHORITY\\SYSTEM<br \/>\nRSACCOUNT=NT AUTHORITY\\SYSTEM<br \/>\nSQLBROWSERAUTOSTART=1<br \/>\nSQLAUTOSTART=1<br \/>\nAGTAUTOSTART=1<\/p>\n<p>\u6ce8\uff1aINSTALLOLAPDATADIR\uff0c\u6570\u636e\u5e93\u6587\u4ef6\uff08\u5982.mdf\u548c.ldf\uff09\u7684\u9ed8\u8ba4\u5b58\u653e\u76ee\u5f55<br \/>\nASACCOUNT:Analysis Services<br \/>\nRSACCOUNT:Reprot Services<br \/>\nSQLBROWSERAUTOSTART=1  1\u4e3a\u81ea\u52a8\u542f\u52a8\uff0c0\u4e3a\u624b\u52a8\u542f\u52a8\u3002<br \/>\nSQLAUTOSTART=1<br \/>\nAGTAUTOSTART=1<br \/>\nSECURITYMODE=SQL \uff1a\u8eab\u4efd\u9a8c\u8bc1\u6a21\u5f0f\uff0c\u5f53\u4e3asql\u65f6\u8868\u793a\u6df7\u5408\u9a8c\u8bc1\uff0c\u82e5\u672a\u6307\u5b9a\uff0c\u5219\u662fwindows\u9a8c\u8bc1<\/p>\n<p>SQLServer2005SP3-KB955706-x86-CHS.exe \/quiet \/allinstances <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53c2\u8003\uff1ahttp:\/\/technet.microsoft.com\/zh-cn\/library\/ms144259( [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1793","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=1793"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1793\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}