{"id":7130,"date":"2021-02-19T10:46:28","date_gmt":"2021-02-19T02:46:28","guid":{"rendered":"http:\/\/www.h540305.idv.tw\/?p=7130"},"modified":"2026-03-17T09:39:10","modified_gmt":"2026-03-17T01:39:10","slug":"server-2016-standard-sql-server-2005-2019","status":"publish","type":"post","link":"https:\/\/www.techx.idv.tw\/index.php\/2021\/02\/19\/server-2016-standard-sql-server-2005-2019\/","title":{"rendered":"\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u8cc7\u8a0a\uff0e\u97f3\u6a02\u4eba\u540c\u5b78\u6703 – SERVER \u5b89\u88dd\u597d\u5f8c\u4e3b\u6a5f\u53ca\u5de5\u4f5c\u7ad9\u5982\u4f55\u8a2d\u5b9a\u624d\u53ef\u6b63\u5e38\u9023\u7dda\u5462 ?"},"content":{"rendered":"
<\/div>

\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong><\/mark><\/strong><\/p>

rockylinux<\/p><\/div><\/div>\n\n\n

<\/p>\n\n\n\n

\u7d66\u656c\u611b\u7684\u8b80\u8005\uff01<\/strong><\/span><\/p>\n\n\n\n

\u5728\u95b1\u8b80\u524d\uff0c\u8acb\u5bb9\u8a31\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong><\/mark><\/strong> –<\/mark><\/strong> \u8072\u660e\u5e7e\u4ef6\u4e8b\u60c5\uff0c\u9019\u4e9b\u4e8b\u60c5\u5c0d\u60a8\u53ef\u80fd\u883b\u91cd\u8981\u7684\uff1a<\/p>\n\n\n\n

\u2b50\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong><\/mark><\/strong><\/mark> <\/mark>–<\/mark><\/strong> \u79c9\u6301\u8457\u5ba2\u89c0\u3001\u516c\u6b63\u3001\u8aa0\u4fe1\u7684\u539f\u5247\u3002<\/p>\n\n\n\n

\u2b50\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong><\/mark><\/mark> – <\/strong>\u53c3\u52a0\u806f\u76df\u8a08\u756b<\/a><\/strong>\uff0c\u4f46\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong> –<\/mark><\/strong> \u4fdd\u8b49\u4e0d\u5f71\u97ff\u60a8\u7684\u8cfc\u8cb7\u6b0a\u76ca\u3002<\/p>\n\n\n\n

\u2b50\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong><\/mark><\/mark> –<\/strong> \u7684\u806f\u76df\u8a08\u756b<\/a><\/mark><\/strong>\u548c\u5ee3\u544a\u6536\u5165\u90fd\u5c07\u7528\u65bc\u7db2\u7ad9\u6c38\u7e8c\u7d93\u71df\u548c\u63a8\u5ee3\u3002<\/p>\n\n\n\n

\u5e74\u8f15\u6709\u70ba\u7684\u5fd7\u9d3b<\/span>\u8cc7\u8a0a\u5de5\u7a0b\u5e2b\u628a\u5ba2\u6236\u8981\u51fa\u7684<\/mark> <\/strong>LENOVO ST50<\/a> <\/strong>Server 2016 Standard \u65b0\u4e3b\u6a5f\u9806\u5229\u9001\u9054\uff0c\u4f46\u5b89\u88dd\u597d\u5f8c\u5de5\u4f5c\u7ad9\u7121\u6cd5\u9023\u5230\u4e3b\u6a5f<\/mark>\uff0c\u6703\u662f\u4ec0\u9ebc\u539f\u56e0\u9020\u6210\u7684\u5462\uff1f \u5fd7\u9d3b<\/span>\u7684<\/mark>\u6545\u4e8b\u7531\u73fe\u5728\u958b\u59cb\uff0c\u8b93\u6211\u5011\u4e00\u8d77\u770b\u4e0b\u53bb\uff0c\u4e2d\u9014\u8981\u4f11\u606f\u4e00\u4e0b\uff0c\u624d\u4e0d\u6703\u9020\u6210\u773c\u775b\u50b7\u5bb3 ( \u5c0f\u7de8\u5c0f\u5fe0\u8a00 )\u3002<\/mark><\/p>\n\n\n\n

\u5047\u8a2d\u4e3b\u6a5f\u96fb\u8166\u540d\u7a31\u70ba SERVER<\/mark><\/strong>\uff0c\u516c\u53f8\u4ee3\u8868\u70ba https:\/\/songbor.com.tw<\/a>\uff0cSQL SERVER \u70ba 2008 R2<\/mark><\/strong><\/p>\n\n\n\n

STEP 1\uff1a\u6e96\u5099\u958b\u555f SQL SERVER 2008 R2 \u7d44\u614b\u7ba1\u7406\u54e1 <\/p>\n\n\n\n

STEP 2\uff1a\u5728 SQL Server Configuration Manager \u756b\u9762\u4e4b [ SQL Server \u7db2\u8def\u7d44\u614b<\/strong><\/mark> ] \u4e0b\u4e4b [ MSSQLSERVER \u7684\u901a\u8a0a\u5354\u5b9a ] \u53f3\u5074 [ \u901a\u8a0a\u5354\u5b9a\u540d\u7a31 ] \u4e4b { [ ( \u5177\u540d\u7ba1\u9053<\/strong><\/mark> ) \u53ca ( TCP\/IP<\/span> ) ] \u7686\u6539\u6210 { \u5df2\u555f\u7528<\/mark><\/strong> } 10-17-2024<\/strong><\/p>\n\n\n\n

STEP 3\uff1a\u5728 Microsoft SQL Server Configuration Studio \u756b\u9762\u4e4b [ \u7269\u4ef6\u7e3d\u7ba1 ] \u4e0b\u4e4b [ SERVER(SQL Server 10.50.1600-SERVER\\Admin) ] \u9ede\u64ca\u6ed1\u9f20 [ \u53f3\u9375 ] \u5728 [ \u5c6c\u6027(R) ] \u6309\u5de6\u9375\u9032\u5165 [ (\u4f3a\u670d\u5668\u5c6c\u6027-SERVER) ] \u756b\u9762<\/p>\n\n\n\n

STEP 4\uff1a\u5728 [ (\u4f3a\u670d\u5668\u5c6c\u6027-SERVER) ] \u756b\u9762\u4e0b [ \u5b89\u5168\u6027 ] \u9801\u9762\u53f3\u5074 [ \u4f3a\u670d\u5668\u9a57\u8b49 ] \u9078\u53d6 { [ SQL Server \u53ca Windows \u9a57\u8b49\u6a21\u5f0f(S) ] }<\/p>\n\n\n\n

STEP 5\uff1a\u5728 Microsoft SQL Server Configuration Studio \u756b\u9762\u4e4b [ \u7269\u4ef6\u7e3d\u7ba1 ] \u4e0b\u4e4b [ \u5b89\u5168\u6027 ] \u767b\u5165 \u65b0\u589e { sbi }<\/p>\n\n\n\n

STEP 6\uff1a\u5728 Microsoft SQL Server Configuration Studio \u756b\u9762\u4e4b [ \u7269\u4ef6\u7e3d\u7ba1 ] \u4e0b\u4e4b [ \u5b89\u5168\u6027 ] \u767b\u5165\u4e0b\u4e4b { sbi } \u9ede\u64ca\u6ed1\u9f20 [ \u53f3\u9375 ] \u5728 { [ \u5c6c\u6027(R) ] \u6309\u5de6\u9375\u9032\u5165\u9032\u5165 [ (\u767b\u5165\u5c6c\u6027-sbi) ] \u756b\u9762<\/p>\n\n\n\n

STEP 7\uff1a\u5728 [ (\u767b\u5165\u5c6c\u6027-sbi) ] \u4e4b [ \u9078\u53d6\u9801\u9762 ] \u4e0b\u4e4b [ \u4e00\u822c ] \u53f3\u5074 [ \u767b\u5165\u540d\u7a31(N) ] \u6b04\u4f4d\u9375\u5165 { sbi } \u53ca \u4e0b\u65b9\u6253\u5165 [ \u5bc6\u78bc<\/span><\/strong> ] \u53ca [ \u53d6\u6d88 ] [ \u6307\u5b9a\u820a\u5bc6\u78bc(I)<\/strong><\/span> ] \u6b04\u4f4d<\/p>\n\n\n\n

STEP 8\uff1a\u5728 [ (\u767b\u5165\u5c6c\u6027-sbi) ] \u4e4b [ \u9078\u53d6\u9801\u9762 ] \u4e0b\u4e4b [ \u4f3a\u670d\u5668\u89d2\u8272 ] \u53f3\u5074 [ \u4f3a\u670d\u5668\u89d2\u8272(S) ] \u4e0b\u65b9\u9078\u64c7 { sysadmin<\/span><\/strong> } \u6b04\u4f4d<\/p>\n\n\n\n

STEP 9\uff1a\u5728 SQL Server Configuration Manager \u756b\u9762\u4e4b [ SQL Server \u7d44\u614b\u7ba1\u7406\u54e1(\u672c\u6a5f) ] \u4e0b\u4e4b [ SQLServer \u670d\u52d9 ] \u53f3\u5074 [ SQL Server(MSSQLSERVER) ] \u6309\u6ed1\u9f20\u53f3\u9375<\/span><\/strong>\u518d\u5de6\u9375<\/strong><\/span>\u9ede\u9078 ( \u91cd\u65b0\u555f\u52d5<\/em><\/strong><\/span> )\uff0c \u6ce8\u610f { SQL Server \u670d\u52d9\u91cd\u65b0\u555f\u52d5<\/strong><\/span>\u8981\u5728 [ ( \u4ee5\u4e0a\u5168\u90e8\u52d5\u4f5c\u5b8c\u6210<\/strong>\u5f8c<\/span> ) \u518d\u505a<\/strong><\/span> SQL Server \u670d\u52d9\u91cd\u65b0\u555f\u52d5<\/em><\/span><\/strong> ) ] } \u52d5\u4f5c<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

STEP 10\uff1a\u65b0\u589e\u4e00\u500b\u767b\u5165\u540d\u7a31\u70ba ( guest ) \u53ca ( sbi \u6539\u5bc6\u78bc\u70ba 22643364 ) \u6d41\u7a0b<\/mark><\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

STEP 11\uff1a\u5efa\u8b70\u6ce8\u610f\u4e8b\u9805<\/strong><\/span><\/p>\n\n\n\n

1. SBI dsn \u6a94 ( \u8cc7\u6599\u4f86\u6e90\u540d\u7a31 ) <\/span><\/strong>SBI \u61c9\u7528\u7a0b\u5f0f\u7528\u4f86\u8981\u6c42\u9023\u7dda\u81f3 ODBC \u8cc7\u6599\u4f86\u6e90\u7684\u540d\u7a31\u8a2d\u5b9a\uff0c\u4ee5\u672c\u4f8b\u5de5\u4f5c\u7ad9\u8a2d\u5b9a\u8aaa\u660e SERVER=192.168.50.94<\/p>\n\n\n\n

DBQ=\\\\192.168.50.94\\WNSH\\WNSH.mdb<\/p>\n\n\n\n

2.SQL Server 2008 R2<\/strong> \u5b89\u88dd\u5f8c<\/strong><\/span>\u52ff\u66f4\u6539<\/strong><\/span>\u96fb\u8166\u540d\u7a31<\/span><\/em><\/strong>\uff0c\u4ee5\u514d SQL Server 2008 R2<\/strong> \u9023\u7d50\u932f\u8aa4<\/span><\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

STEP 12\uff1a\u958b\u555f\u9060\u7aef\u684c\u9762\u9023\u7dda<\/mark><\/strong> 10-24-2024<\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\u53ef\u53c3\u8003\u5c0f\u7de8\u7684\u53e6\u4e00\u7bc7\u6587\u7ae0<\/a>\uff0c \u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08<\/mark>\u6ce8<\/mark>\u5167<\/mark>\u5bb9<\/mark>\u70ba<\/mark>\u60a8<\/mark><\/strong> –<\/mark><\/strong> \u5982\u4f55\u505a ( SQL Server 2008 R2 \u8cc7\u6599\u5eab\u9084\u539f ) \u2013 \u4eab\u6280\u6c34\u5de5\u574a TechX Studio ( One More WebMaster ) 09-08-2021<\/mark><\/strong><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u7d66\u656c\u611b\u7684\u8b80\u8005\uff01 \u5728\u95b1\u8b80\u524d\uff0c\u8acb\u5bb9\u8a31\u4eab\u6280\u6c34\u5de5\u574a TechX Studio\uff0c\u5c08\u6ce8\u5167\u5bb9\u70ba\u60a8 – \u8072\u660e\u5e7e\u4ef6\u4e8b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9],"tags":[84],"class_list":["post-7130","post","type-post","status-publish","format-standard","hentry","category-editors-notes","tag-server-2016-standard-sql-server-2005-2019"],"blocksy_meta":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/7130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/comments?post=7130"}],"version-history":[{"count":1,"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/7130\/revisions"}],"predecessor-version":[{"id":20475,"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/7130\/revisions\/20475"}],"wp:attachment":[{"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/media?parent=7130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/categories?post=7130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techx.idv.tw\/index.php\/wp-json\/wp\/v2\/tags?post=7130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}