{"id":588,"date":"2011-11-04T10:59:02","date_gmt":"2011-11-04T02:59:02","guid":{"rendered":"https:\/\/tgh.idv.tw\/wordpress\/archives\/588"},"modified":"2014-12-08T15:07:04","modified_gmt":"2014-12-08T07:07:04","slug":"windows-sql-server-2008-express-tcpip-%e9%80%a3%e7%b7%9a%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/tgh.idv.tw\/?p=588","title":{"rendered":"[\u8edf\u9ad4\u76f8\u95dc] SQL Server 2008 Express TCP\/IP \u9023\u7dda\u8a2d\u5b9a"},"content":{"rendered":"<ul>\n<li>\u8cc7\u6599\u5eab\u8a2d\u5b9a<\/li>\n<\/ul>\n<p>\u5728\u7d44\u614b\u7ba1\u7406\u54e1\u628aTCP\/IP \u555f\u7528<\/p>\n<p><a href=\"https:\/\/tgh.idv.tw\/wordpress\/wp-content\/uploads\/2011\/11\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"image\" src=\"https:\/\/tgh.idv.tw\/wordpress\/wp-content\/uploads\/2011\/11\/image_thumb.png\" alt=\"image\" width=\"188\" height=\"244\" border=\"0\" \/><\/a><\/p>\n<p>\u5207\u63db\u5230IP\u4f4d\u5740\u9801\u7c64\uff0c\u6700\u5f8c\u4e00\u500bTCP\u9023\u63a5\u57e0\u8f38\u5165\u4f60\u8981\u958b\u653e\u7684\u865f\u78bc\u00a0\u00a0 (\u4e00\u822cmssql\u9810\u8a2d\u662f1433)<\/p>\n<p><a href=\"https:\/\/tgh.idv.tw\/wordpress\/wp-content\/uploads\/2011\/11\/image1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"image\" src=\"https:\/\/tgh.idv.tw\/wordpress\/wp-content\/uploads\/2011\/11\/image_thumb1.png\" alt=\"image\" width=\"244\" height=\"172\" border=\"0\" \/><\/a><\/p>\n<ul>\n<li>\u9023\u7d50\u8a2d\u5b9a<\/li>\n<\/ul>\n<p>\u900f\u904eADO or ODBC \u9023\u7dda<\/p>\n<p><a href=\"https:\/\/tgh.idv.tw\/wordpress\/wp-content\/uploads\/2011\/11\/image2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"image\" src=\"https:\/\/tgh.idv.tw\/wordpress\/wp-content\/uploads\/2011\/11\/image_thumb2.png\" alt=\"image\" width=\"233\" height=\"244\" border=\"0\" \/><\/a><\/p>\n<p>\u5728\u4f3a\u670d\u5668\u540d\u7a31\u9019\u908a\u8981<span style=\"color: #ff0000; font-family: \u5fae\u8edf\u6b63\u9ed1\u9ad4; font-size: small;\"><strong>\u7279\u5225\u6ce8\u610f\uff0c\u6700\u597d\u8f38\u5165\u00a0 \u4e3b\u6a5f\u540d\u7a31(ip)\\\u5225\u540d,\u9023\u63a5\u57e0<\/strong><\/span><\/p>\n<p>ex:192.168.1.152\\sqlexpress,1433<\/p>\n<p>&nbsp;<\/p>\n<p>\u5ef6\u4f38\u95b1\u8b80\uff1a<\/p>\n<h4><a href=\"http:\/\/blog.miniasp.com\/post\/2007\/12\/28\/How-to-enable-SQL-Express-TCP-IP-connection.aspx\"><span style=\"font-size: small;\">\u8b93 SQLExpress \u8cc7\u6599\u5eab\u958b\u555f TCP\/IP \u9023\u7dda\u7684\u65b9\u5f0f <\/span><\/a><\/h4>\n<h4><a href=\"http:\/\/blog.miniasp.com\/post\/2011\/05\/24\/SQL-Server-Standard-as-SQL-Server-Express-using-Alias.aspx\"><span style=\"font-size: small;\">\u5982\u4f55\u628a SQL Server \u6a19\u6e96\u7248\u7576\u6210 SQL Server Express \u4f86\u7528 <\/span><\/a><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>\u8cc7\u6599\u5eab\u8a2d\u5b9a \u5728\u7d44\u614b\u7ba1\u7406\u54e1\u628aTCP\/IP \u555f\u7528 \u5207\u63db\u5230IP\u4f4d\u5740\u9801\u7c64\uff0c\u6700\u5f8c\u4e00\u500bTCP\u9023\u63a5\u57e0\u8f38\u5165\u4f60\u8981\u958b\u653e\u7684\u865f\u78bc\u00a0\u00a0 &hellip;<\/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":[21],"tags":[22],"_links":{"self":[{"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/588"}],"collection":[{"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=588"}],"version-history":[{"count":1,"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/588\/revisions"}],"predecessor-version":[{"id":848,"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/588\/revisions\/848"}],"wp:attachment":[{"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tgh.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}