{"id":4396,"date":"2024-03-26T09:00:00","date_gmt":"2024-03-26T02:00:00","guid":{"rendered":"https:\/\/longvan.net\/cong-dong\/?p=4396"},"modified":"2024-05-21T16:48:56","modified_gmt":"2024-05-21T09:48:56","slug":"huong-dan-mo-port-sql-truy-cap-remote-tu-xa","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa"},"content":{"rendered":"<p>M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c Enable Remote SQL Server l\u00e0 k\u00edch ho\u1ea1t t\u00ednh n\u0103ng cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb xa c\u1ee7a SQL Server v\u00e0 thi\u1ebft l\u1eadp c\u1ed5ng nghe (Listenning Port) cho SQL Server.<br \/>\nC\u00f3 1 v\u00e0i tr\u01b0\u1eddng h\u1ee3p b\u1ea1n th\u1ef1c hi\u1ec7n remote v\u00e0o MSSQL-server s\u1ebd g\u1eb7p th\u00f4ng b\u00e1o sau:<\/p>\n<p>Nguy\u00ean nh\u00e2n ph\u00e1t sinh do SQL server kh\u00f4ng \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh cho ph\u00e9p m\u00e1y t\u00ednh kh\u00e1c truy c\u1eadp t\u1eeb xa v\u00e0o \u0111\u1ec3 qu\u1ea3n l\u00fd database ( hay c\u00f2n g\u1ecdi l\u00e0 remote MSSQL-server).<\/p>\n<p>V\u1eady l\u00e0m sao \u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 enable remote SQL server ? \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u1ea1n c\u1ea7n tr\u01b0\u1edbc ti\u00ean l\u00e0 t\u1ea1m th\u1eddi disalbe firewall, ho\u1eb7c m\u1edf port 1433 m\u1eb7c \u0111\u1ecbnh c\u1ee7a SQL sau \u0111\u00f3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<h3><strong>I. H\u01b0\u1edbng d\u1eabn c\u1ea5u h\u00ecnh<\/strong><\/h3>\n<p><strong>1.<\/strong> B\u01b0\u1edbc 1: truy c\u1eadp <strong>SQL Server Management Studio<\/strong> k\u1ebft n\u1ed1i \u0111\u1ebfn <strong>SQL Server<\/strong> &gt; <strong>Properties<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4776 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png\" alt=\"\" width=\"232\" height=\"449\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png 232w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3-155x300.png 155w\" sizes=\"auto, (max-width: 232px) 100vw, 232px\" \/><br \/>\n<strong>2.<\/strong> B\u01b0\u1edbc 2: ch\u1ecdn <strong>Connections<\/strong> &gt; <strong>Allow remote connection to this server<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4782 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/2-2.png\" alt=\"\" width=\"690\" height=\"625\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/2-2.png 690w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/2-2-300x272.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/p>\n<p><strong>3.<\/strong> B\u01b0\u1edbc 3: truy c\u1eadp <strong>SQL Server Configuration Manager <\/strong>trong Start<br \/>\nsau \u0111\u00f3 ch\u1ecdn\u00a0<strong>SQLServerNetworkConfiguration<\/strong>\u00a0&gt; <strong>Protocols for SQLEXPRESS (2) &gt;<\/strong>\u00a0ki\u1ec3m tra tr\u1ea1ng th\u00e1i <strong>TCP\/IP<\/strong> \u0111ang t\u1eaft l\u00e0 <strong>disable <\/strong>ta\u00a0th\u00ec c\u1ea7n <strong>enable (3)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4784 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/3-2.png\" alt=\"\" width=\"520\" height=\"271\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/3-2.png 520w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/3-2-300x156.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<p><strong>4. <\/strong>B\u01b0\u1edbc 4: Sau khi <strong>enable<\/strong> ta c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecba ch\u1ec9 <strong>IP m\u00e1y ch\u1ee7<\/strong> v\u00e0 <strong>c\u1ed5ng k\u1ebft n\u1ed1i (port)<\/strong><br \/>\n\u0110i\u1ec1u ch\u1ec9nh <strong>IP Address<\/strong> th\u00e0nh <strong>IP<\/strong> m\u00e1y ch\u1ee7 \u0111ang s\u1eed d\u1ee5ng, \u0111\u1ed3ng th\u1eddi c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb <strong>TCP Port<\/strong> th\u00e0nh <strong>1443<br \/>\n<\/strong>ch\u1ecdn m\u1ee5c <strong>IP Addresses<\/strong> cu\u1ed9n xu\u1ed1ng m\u1ee5c<strong> IP ALL<\/strong> \u0111\u1ec3 thay \u0111\u1ed5i <strong>c\u1ed5ng k\u1ebft n\u1ed1i<\/strong> c\u1ee7a SQL<br \/>\nta thi\u1ebft \u0111\u1eb7t gi\u00e1 tr\u1ecb <strong>TCP port<\/strong>\u00a0 ban \u0111\u1ea7u 1433 sang 1443 nh\u01b0 sau:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4788 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/4-2.png\" alt=\"\" width=\"422\" height=\"473\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/4-2.png 422w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/4-2-268x300.png 268w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><\/p>\n<p><strong>5. <\/strong>B\u01b0\u1edbc 5: kh\u1edfi \u0111\u1ed9ng l\u1ea1i d\u1ecbch v\u1ee5 <strong>SQL Server<\/strong>.<br \/>\nta v\u00e0o m\u1ee5c <strong>SQL Server Services<\/strong>, \u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ee5c <strong>SQL Server (MSSQLSERVER)<\/strong> -&gt; Ch\u1ecdn <strong>Restart<br \/>\n<\/strong>m\u1ee5c n\u00e0y n\u1eb1m trong<strong> Sql Server Configuration Manager <\/strong>\u1edf<strong> b\u01b0\u1edbc 3<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4790 size-full\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/6-1.png\" alt=\"\" width=\"587\" height=\"331\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/6-1.png 587w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/6-1-300x169.png 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/p>\n<p><strong>6. <\/strong>B\u01b0\u1edbc 6: M\u1edf c\u1ed5ng k\u1ebft n\u1ed1i \u0111\u1ec3 truy c\u1eadp t\u1eeb xa<br \/>\nn\u1ebfu Qu\u00fd Kh\u00e1ch ch\u01b0a bi\u1ebft c\u00e1ch m\u1edf port tr\u00ean server c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn sau<br \/>\n<a href=\"https:\/\/longvan.net\/cong-dong\/huong-dan-cau-hinh-mo-port-tren-windows-firewall\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u1ea5u h\u00ecnh m\u1edf port tr\u00ean Windows Firewall \u2013 Long V\u00e2n (longvan.net)<\/a><br \/>\n\u1edf h\u01b0\u1edbng d\u1eabn n\u00e0y ta c\u1ea7n m\u1edf port <strong>1443<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng cho remote t\u1eeb xa<\/p>\n<h3><strong>II. H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t t\u00e0i kho\u1ea3n &#8220;sa&#8221;\u00a0<\/strong><\/h3>\n<p><strong>1.<\/strong> B\u01b0\u1edbc 1: truy c\u1eadp <strong>SQL Server Management Studio<\/strong> v\u00e0 k\u1ebft n\u1ed1i v\u1edbi <strong>Windows Authentication<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4793 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/8-2.png\" alt=\"\" width=\"412\" height=\"310\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/8-2.png 412w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/8-2-300x226.png 300w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/p>\n<p><strong>2.<\/strong> B\u01b0\u1edbc 2: ch\u1ecdn chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ee5c <strong>SQLEXPRESS<\/strong> v\u00e0 ch\u1ecdn <strong>Properties<\/strong><br \/>\nsau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Security (1)<\/strong> &gt;\u00a0<strong>SQL Server and Windows Authentication mode (2) &gt; OK (3)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4798 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/9-1.png\" alt=\"\" width=\"690\" height=\"625\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/9-1.png 690w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/9-1-300x272.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/p>\n<p><strong>3. <\/strong>B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 <strong>Object Explorer<\/strong> ch\u1ecdn m\u1ee5c <strong>Security (1) &gt;<\/strong> <strong>Logins (2)<\/strong>\u00a0&gt; ch\u1ecdn chu\u1ed9t ph\u1ea3i v\u00e0o user <strong>sa (3)<\/strong> ch\u1ecdn <strong>Properties (4)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4800 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/10-1.png\" alt=\"\" width=\"249\" height=\"517\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/10-1.png 249w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/10-1-144x300.png 144w\" sizes=\"auto, (max-width: 249px) 100vw, 249px\" \/><\/p>\n<p><strong>4.<\/strong> B\u01b0\u1edbc 4: ch\u1ecdn <strong>Status (1)<\/strong>\u00a0 sau \u0111\u00f3 ch\u1ecdn <strong>Grant (2)<\/strong>\u00a0v\u00e0 <strong>Enabled (3) &gt; OK (3)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4802 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/11.png\" alt=\"\" width=\"690\" height=\"625\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/11.png 690w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/11-300x272.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/p>\n<p><strong>5.<\/strong> B\u01b0\u1edbc 5: Ti\u1ebfp theo ch\u1ecdn <strong>General<\/strong> sau \u0111\u00f3 nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0 g\u00f5 l\u1ea1i m\u1eadt kh\u1ea9u nh\u01b0 h\u00ecnh <strong>m\u1ee5c<\/strong> <strong>1 &gt; OK (2)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4803 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/12.png\" alt=\"\" width=\"690\" height=\"625\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/12.png 690w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/12-300x272.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/p>\n<p><strong>6.<\/strong> B\u01b0\u1edbc 6: Sau \u0111\u00f3 ta c\u00f3 th\u1ec3 tho\u00e1t v\u00e0 truy c\u1eadp l\u1ea1i <strong>SQL Server Management Studio<br \/>\n<\/strong>ch\u1ecdn\u00a0<strong>Authentication &gt; SQL Server Authentication.<\/strong> v\u00e0 truy c\u1eadp v\u1edbi user <strong>sa<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4393 size-full aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/02\/Screenshot_19-2-e1714063435822.png\" alt=\"\" width=\"478\" height=\"307\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/02\/Screenshot_19-2-e1714063435822.png 478w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/02\/Screenshot_19-2-e1714063435822-300x193.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/p>\n<p>Sau \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i v\u00e0 s\u1eed d\u1ee5ng b\u00ecnh th\u01b0\u1eddng d\u1ecbch v\u1ee5 SQL<br \/>\nNh\u01b0 v\u1eady Long V\u00e2n \u0111\u00e3 ho\u00e0n t\u1ea5t h\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa, ch\u00fac Qu\u00fd Kh\u00e1ch th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c Enable Remote SQL Server l\u00e0 k\u00edch ho\u1ea1t t\u00ednh n\u0103ng cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb xa c\u1ee7a SQL Server v\u00e0 thi\u1ebft l\u1eadp c\u1ed5ng nghe (Listenning Port) cho SQL Server. C\u00f3 1 v\u00e0i tr\u01b0\u1eddng h\u1ee3p b\u1ea1n th\u1ef1c hi\u1ec7n remote v\u00e0o MSSQL-server s\u1ebd g\u1eb7p th\u00f4ng b\u00e1o sau: Nguy\u00ean nh\u00e2n ph\u00e1t sinh do SQL server [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_oasis_is_in_workflow":0,"_oasis_original":0,"footnotes":""},"categories":[15],"tags":[304,306,305],"class_list":["post-4396","post","type-post","status-publish","format-standard","hentry","category-windows","tag-enable-user-sa","tag-remote-sql","tag-windows-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa - Long V\u00e2n<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa - Long V\u00e2n\" \/>\n<meta property=\"og:description\" content=\"M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c Enable Remote SQL Server l\u00e0 k\u00edch ho\u1ea1t t\u00ednh n\u0103ng cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb xa c\u1ee7a SQL Server v\u00e0 thi\u1ebft l\u1eadp c\u1ed5ng nghe (Listenning Port) cho SQL Server. C\u00f3 1 v\u00e0i tr\u01b0\u1eddng h\u1ee3p b\u1ea1n th\u1ef1c hi\u1ec7n remote v\u00e0o MSSQL-server s\u1ebd g\u1eb7p th\u00f4ng b\u00e1o sau: Nguy\u00ean nh\u00e2n ph\u00e1t sinh do SQL server [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/\" \/>\n<meta property=\"og:site_name\" content=\"Long V\u00e2n\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-26T02:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-21T09:48:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"232\" \/>\n\t<meta property=\"og:image:height\" content=\"449\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ngo\u0323c Ma\u0323nh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ngo\u0323c Ma\u0323nh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/\"},\"author\":{\"name\":\"Ngo\u0323c Ma\u0323nh\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#\\\/schema\\\/person\\\/da44328d290c9a56ee3bfe7cc2abea39\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa\",\"datePublished\":\"2024-03-26T02:00:00+00:00\",\"dateModified\":\"2024-05-21T09:48:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/\"},\"wordCount\":712,\"publisher\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1-3.png\",\"keywords\":[\"enable user sa\",\"remote sql\",\"windows server\"],\"articleSection\":[\"Windows\"],\"inLanguage\":\"vi\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/\",\"url\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa - Long V\u00e2n\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1-3.png\",\"datePublished\":\"2024-03-26T02:00:00+00:00\",\"dateModified\":\"2024-05-21T09:48:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#primaryimage\",\"url\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1-3.png\",\"contentUrl\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1-3.png\",\"width\":232,\"height\":449},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#website\",\"url\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/\",\"name\":\"Long V\u00e2n\",\"description\":\"C\u1ed9ng \u0110\u1ed3ng\",\"publisher\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#organization\",\"name\":\"Long V\u00e2n\",\"url\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/cropped-logo-longvancloudsolution.png\",\"contentUrl\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/cropped-logo-longvancloudsolution.png\",\"width\":1300,\"height\":330,\"caption\":\"Long V\u00e2n\"},\"image\":{\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/#\\\/schema\\\/person\\\/da44328d290c9a56ee3bfe7cc2abea39\",\"name\":\"Ngo\u0323c Ma\u0323nh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8124de7bf50bfe1d8f6f5d0b236e4634d0332a296e9b61576f83314044775b0d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8124de7bf50bfe1d8f6f5d0b236e4634d0332a296e9b61576f83314044775b0d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8124de7bf50bfe1d8f6f5d0b236e4634d0332a296e9b61576f83314044775b0d?s=96&d=mm&r=g\",\"caption\":\"Ngo\u0323c Ma\u0323nh\"},\"sameAs\":[\"https:\\\/\\\/longvan.net\\\/\"],\"url\":\"https:\\\/\\\/longvan.net\\\/cong-dong\\\/author\\\/ngocmanh\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa - Long V\u00e2n","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa - Long V\u00e2n","og_description":"M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c Enable Remote SQL Server l\u00e0 k\u00edch ho\u1ea1t t\u00ednh n\u0103ng cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb xa c\u1ee7a SQL Server v\u00e0 thi\u1ebft l\u1eadp c\u1ed5ng nghe (Listenning Port) cho SQL Server. C\u00f3 1 v\u00e0i tr\u01b0\u1eddng h\u1ee3p b\u1ea1n th\u1ef1c hi\u1ec7n remote v\u00e0o MSSQL-server s\u1ebd g\u1eb7p th\u00f4ng b\u00e1o sau: Nguy\u00ean nh\u00e2n ph\u00e1t sinh do SQL server [&hellip;]","og_url":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/","og_site_name":"Long V\u00e2n","article_published_time":"2024-03-26T02:00:00+00:00","article_modified_time":"2024-05-21T09:48:56+00:00","og_image":[{"width":232,"height":449,"url":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png","type":"image\/png"}],"author":"Ngo\u0323c Ma\u0323nh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Ngo\u0323c Ma\u0323nh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"3 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#article","isPartOf":{"@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/"},"author":{"name":"Ngo\u0323c Ma\u0323nh","@id":"https:\/\/longvan.net\/cong-dong\/#\/schema\/person\/da44328d290c9a56ee3bfe7cc2abea39"},"headline":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa","datePublished":"2024-03-26T02:00:00+00:00","dateModified":"2024-05-21T09:48:56+00:00","mainEntityOfPage":{"@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/"},"wordCount":712,"publisher":{"@id":"https:\/\/longvan.net\/cong-dong\/#organization"},"image":{"@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#primaryimage"},"thumbnailUrl":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png","keywords":["enable user sa","remote sql","windows server"],"articleSection":["Windows"],"inLanguage":"vi"},{"@type":"WebPage","@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/","url":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/","name":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa - Long V\u00e2n","isPartOf":{"@id":"https:\/\/longvan.net\/cong-dong\/#website"},"primaryImageOfPage":{"@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#primaryimage"},"image":{"@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#primaryimage"},"thumbnailUrl":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png","datePublished":"2024-03-26T02:00:00+00:00","dateModified":"2024-05-21T09:48:56+00:00","breadcrumb":{"@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#primaryimage","url":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png","contentUrl":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2024\/03\/1-3.png","width":232,"height":449},{"@type":"BreadcrumbList","@id":"https:\/\/longvan.net\/cong-dong\/huong-dan-mo-port-sql-truy-cap-remote-tu-xa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/longvan.net\/cong-dong\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp port SQL \u0111\u1ec3 truy c\u1eadp t\u1eeb xa"}]},{"@type":"WebSite","@id":"https:\/\/longvan.net\/cong-dong\/#website","url":"https:\/\/longvan.net\/cong-dong\/","name":"Long V\u00e2n","description":"C\u1ed9ng \u0110\u1ed3ng","publisher":{"@id":"https:\/\/longvan.net\/cong-dong\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/longvan.net\/cong-dong\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/longvan.net\/cong-dong\/#organization","name":"Long V\u00e2n","url":"https:\/\/longvan.net\/cong-dong\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/longvan.net\/cong-dong\/#\/schema\/logo\/image\/","url":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/11\/cropped-logo-longvancloudsolution.png","contentUrl":"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/11\/cropped-logo-longvancloudsolution.png","width":1300,"height":330,"caption":"Long V\u00e2n"},"image":{"@id":"https:\/\/longvan.net\/cong-dong\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/longvan.net\/cong-dong\/#\/schema\/person\/da44328d290c9a56ee3bfe7cc2abea39","name":"Ngo\u0323c Ma\u0323nh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/8124de7bf50bfe1d8f6f5d0b236e4634d0332a296e9b61576f83314044775b0d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8124de7bf50bfe1d8f6f5d0b236e4634d0332a296e9b61576f83314044775b0d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8124de7bf50bfe1d8f6f5d0b236e4634d0332a296e9b61576f83314044775b0d?s=96&d=mm&r=g","caption":"Ngo\u0323c Ma\u0323nh"},"sameAs":["https:\/\/longvan.net\/"],"url":"https:\/\/longvan.net\/cong-dong\/author\/ngocmanh\/"}]}},"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/4396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/comments?post=4396"}],"version-history":[{"count":39,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/4396\/revisions"}],"predecessor-version":[{"id":5244,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/4396\/revisions\/5244"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=4396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=4396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=4396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}