{"id":5253,"date":"2023-07-15T23:22:55","date_gmt":"2023-07-15T16:22:55","guid":{"rendered":"https:\/\/www.engisv.info\/?p=5253"},"modified":"2023-07-15T23:57:05","modified_gmt":"2023-07-15T16:57:05","slug":"micrsoft-sql-server-cau-hinh-ma-hoa-cho-ket-noi-sql-server-encryptionconnection-bang-certificate","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=5253","title":{"rendered":"Micrsoft SQL Server &#8211; C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server)"},"content":{"rendered":"<p>\u0110\u1ec3 t\u0103ng c\u01b0\u1eddng t\u00ednh b\u1ea3o m\u1eadt khi truy\u1ec1n d\u1eef li\u1ec7u tr\u00ean \u0111\u01b0\u1eddng truy\u1ec1n, Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u.<\/p>\n<p>\u0110\u1ec3 b\u1eadt t\u00ednh n\u0103ng m\u00e3 h\u00f3a cho k\u1ebft n\u1ed1i SQL server, b\u1ea1n c\u00f3 th\u1ec5 s\u1eed d\u1ee5ng SSL Certificate b\u1ea3n th\u01b0\u01a1ng m\u1ea1i, t\u1eeb <a href=\"https:\/\/www.engisv.info\/?p=137\" target=\"_blank\" rel=\"noopener\">CA Server<\/a> ho\u1eb7c <a href=\"https:\/\/www.engisv.info\/?p=5203\" target=\"_blank\" rel=\"noopener\">self-signed certificate<\/a>. \u0110i\u1ec1u\u00a0 ki\u1ec7n v\u1ec1 SSL Certificate c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c m\u00e3 h\u00f3a k\u1ebft n\u1ed1i\u00a0 SQL server nh\u01b0 sau:<\/p>\n<ul>\n<li>Enhanced Key Usage: l\u00e0 Server Authentication 1.3.6.1.5.5.7.3.1<\/li>\n<li>Valid expiration date:\u00a0 Certificate v\u1ea9n c\u00f2n h\u1ea1n s\u1eed d\u1ee5ng.<\/li>\n<li>Subject Name: \u0111\u01b0\u1ee3c c\u1ea5p v\u1edbi server name c\u1ee7a SQL server.<\/li>\n<li>Certificate \u0111\u01b0\u1ee3c import v\u00e0 <a href=\"https:\/\/www.engisv.info\/?p=5203\" target=\"_blank\" rel=\"noopener\">ch\u1ee9a trong trong\u00a0 certlm.msc<\/a> c\u1ee7a server c\u00e0i \u0111\u1eb7t SQL Server<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5275 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-12.png\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-12.png 407w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-12-238x300.png 238w\" alt=\"\" width=\"407\" height=\"513\" \/><\/p>\n<p><strong>M\u00f4 h\u00ecnh th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5276 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/Mo-Hinh-SSL-SQL-Server.png\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/Mo-Hinh-SSL-SQL-Server.png 576w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/Mo-Hinh-SSL-SQL-Server-300x211.png 300w\" alt=\"\" width=\"576\" height=\"406\" \/><\/p>\n<ul>\n<li><em><strong>Domain:<\/strong>\u00a0<\/em>hoanghiepktv.com<\/li>\n<li><em><strong>SQL Server:<\/strong><\/em>\u00a02022-SRV02.hoanghiepktv.com<\/li>\n<\/ul>\n<p><strong>\u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c enable SSL\/TLS cho SQL server b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0T\u1ea1o SSL Certificate cho SQL server, trong b\u00e0i n\u00e0y ch\u00fang ta\u00a0<a href=\"https:\/\/www.engisv.info\/?p=5203\" target=\"_blank\" rel=\"noopener\">t\u1ea1o self-signed certificate<\/a>\u00a0v\u1edbi<\/p>\n<ul>\n<li><strong>-DnsName<\/strong>: 2022-srv02.hoanghiepktv.com.<\/li>\n<li><strong>-FriendlyName<\/strong>: SQL Server SelfSignedCertificate<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0C\u1ea5p quy\u1ec1n\u00a0<strong>Manage Private Keys<\/strong>\u00a0cho t\u00e0i kho\u1ea3n \u0111ang log on service c\u1ee7a SQL Server.<\/p>\n<p>Th\u00f4ng th\u01b0\u1eddng, m\u1eb7c \u0111\u1ecbnh t\u00e0i kho\u1ea3n log on service c\u1ee7a SQL Server l\u00e0<strong>\u00a0NT Service\\MSSQLSERVER.\u00a0<\/strong>\u0110\u1ec3 bi\u1ebft ch\u00ednh x\u00e1c b\u1ea1n SQL server c\u1ee7a b\u1ea1n \u0111ang d\u00f9ng t\u00e0i kho\u1ea3n n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra trong\u00a0<strong>Sql Server Configuration Manager<\/strong>\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5288 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-13-297x300.png\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-13-297x300.png 297w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-13-150x150.png 150w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-13.png 456w\" alt=\"\" width=\"442\" height=\"446\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5277 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-1.png\" alt=\"\" width=\"629\" height=\"411\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-1.png 980w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-1-300x196.png 300w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-1-768x502.png 768w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/p>\n<p>Truy c\u1eadp v\u00e0o <a href=\"https:\/\/www.engisv.info\/?p=5203\" target=\"_blank\" rel=\"noopener\">Certificates -Local Computer<\/a>, b\u1ea1n th\u1ef1c hi\u1ec7n c\u1ea5p quy\u1ec1n cho t\u00e0i kho\u1ea3n log on service c\u1ee7a SQL server nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5278 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-2.png\" alt=\"\" width=\"684\" height=\"237\" \/><\/p>\n<p>Trong c\u1eeda s\u1ed5 <strong>Select Users and Groups<\/strong>, b\u1ea1n nh\u1eadp v\u00e0o username c\u1ee7a t\u00e0i kho\u1ea3n log on service c\u1ee7a SQL server ( trong b\u00e0i n\u00e0y s\u1eed d\u1ee5ng t\u00e0i kho\u1ea3n m\u1eb7c \u0111\u1ecbnh khi c\u00e0i \u0111\u1eb7t l\u00e0 NT Service\\MSSQLSERVER) v\u00e0 <strong>Check Names<\/strong>.<\/p>\n<ul>\n<li><em>L\u01b0u \u00fd: T\u00e0i kho\u1ea3n log on service c\u1ee7a SQL\u00a0 server c\u00f3 th\u1ec3 l\u00e0 t\u1ea3i kho\u1ea3n c\u1ee7a Domian Controller, l\u00fac n\u00e0y b\u1ea1n ph\u1ea3i ch\u1ecdn<strong> Locations<\/strong> l\u00e0 Domain n\u01a1i ch\u1ee9a t\u00e0i kho\u1ea3n.<\/em><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5279 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-3.png\" sizes=\"auto, (max-width: 687px) 100vw, 687px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-3.png 814w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-3-300x165.png 300w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-3-768x424.png 768w\" alt=\"\" width=\"687\" height=\"379\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5280 size-full\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-4.png\" alt=\"\" width=\"363\" height=\"453\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-4.png 363w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-4-240x300.png 240w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: B\u1eadt t\u00ednh n\u0103ng SSL\/TLS cho SQL server:<\/p>\n<p>\u0110\u1ec3 b\u1eadt t\u00ednh n\u0103ng m\u00e3 h\u00f3a SSL\/TLS cho SQL server, b\u1ea1n truy c\u1eadp v\u00e0o <strong>Sql Server Configuration Manager<\/strong> v\u00e0 ti\u1ebfn h\u00e0nh th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5281 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-5.png\" alt=\"\" width=\"420\" height=\"346\" \/><\/p>\n<p>Ch\u1ecdn<strong> Certificate<\/strong> c\u00f3 FriendlyName l\u00e0 <em><strong>SQL Server SelfSignedCertificate<\/strong><\/em> nh\u01b0 \u0111\u00e3 t\u1ea1o \u1edf b\u01b0\u1edbc 1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5282 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-6.png\" alt=\"\" width=\"425\" height=\"402\" \/><\/p>\n<p>\u0110\u1ec3 b\u1eaft bu\u1ed9c t\u1ea5t c\u1ea3 k\u1ebft n\u1ed1i t\u1eeb client \u0111\u1ebfn server ph\u1ea3i s\u1eed d\u1ee5ng t\u00ednh n\u0103ng m\u00e3 h\u00f3a, b\u1ea1n ch\u1ecdn m\u1ee5c<strong> Force Encryption<\/strong> l\u00e0 <strong>Yes<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5283 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-7.png\" alt=\"\" width=\"347\" height=\"418\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5284 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-8.png\" alt=\"\" width=\"667\" height=\"249\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0<a href=\"https:\/\/www.engisv.info\/?p=5219\" target=\"_blank\" rel=\"noopener\">Export self-signed certificate<\/a>\u00a0tr\u00ean SQL server v\u00e0\u00a0<a href=\"https:\/\/www.engisv.info\/?p=5235\" target=\"_blank\" rel=\"noopener\">Import self-signed certificate<\/a>\u00a0v\u00e0o Trusted Root Certificate Authorities c\u1ee7a server ch\u1ee9a application c\u1ea7n k\u1ebft n\u1ed1i database c\u1ee7a SQL server ho\u1eb7c tr\u00ean m\u00e1y Client k\u1ebft n\u1ed1i SQL server \u0111\u1ec3 truy v\u1ea5n d\u1eef li\u1ec7u.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> K\u1ebft n\u1ed1i SQL server t\u1eeb Client tr\u00ean <a href=\"https:\/\/www.engisv.info\/?p=2183\" target=\"_blank\" rel=\"noopener\">SQL Server Management Studio (SSMS)<\/a>:<\/p>\n<p>Sau khi b\u1eadt t\u00ednh n\u0103ng Enforce Encryption, b\u1ea1n truy c\u1eadp SQL sever s\u1ebd b\u1ecb l\u1ed7i n\u1ebfu kh\u00f4ng ch\u1ecdn Encrypt Connection:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5285 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-9.png\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-9.png 936w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-9-300x107.png 300w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-9-768x274.png 768w\" alt=\"\" width=\"664\" height=\"237\" \/><\/p>\n<p>B\u1ea1n ti\u1ebfn h\u00e0nh k\u1ebft n\u1ed1i\u00a0 SQL serer b\u1eb1ng\u00a0<a href=\"https:\/\/www.engisv.info\/?p=2183\" target=\"_blank\" rel=\"noopener\">SSMS<\/a>\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5286 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-10.png\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-10.png 478w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-10-300x198.png 300w\" alt=\"\" width=\"411\" height=\"272\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5287 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-11.png\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-11.png 476w, https:\/\/www.engisv.info\/wp-content\/uploads\/2023\/07\/SSL-SQL-server-11-276x300.png 276w\" alt=\"\" width=\"420\" height=\"456\" \/><\/p>\n<p>Do trong b\u00e0i n\u00e0y ch\u00fang ta d\u00f9ng Self-Signed Certificate, n\u00ean khi k\u1ebft n\u1ed1i ch\u00fang ta ph\u1ea3i ch\u1ecdn Trust server cetificate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ec3 t\u0103ng c\u01b0\u1eddng t\u00ednh b\u1ea3o m\u1eadt khi truy\u1ec1n d\u1eef li\u1ec7u tr\u00ean \u0111\u01b0\u1eddng truy\u1ec1n, Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. \u0110\u1ec3 b\u1eadt t\u00ednh n\u0103ng m\u00e3 h\u00f3a cho k\u1ebft n\u1ed1i SQL server, b\u1ea1n c\u00f3 th\u1ec5 s\u1eed d\u1ee5ng SSL Certificate b\u1ea3n th\u01b0\u01a1ng m\u1ea1i, t\u1eeb CA Server ho\u1eb7c self-signed certificate. \u0110i\u1ec1u\u00a0 ki\u1ec7n v\u1ec1 SSL Certificate c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c m\u00e3 h\u00f3a k\u1ebft n\u1ed1i\u00a0 SQL server&hellip;<\/p>\n","protected":false},"author":2,"featured_media":4404,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"footnotes":""},"categories":[22,7],"tags":[29,50],"class_list":["post-5253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-kien-thuc","tag-certificate","tag-microsoft-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Micrsoft SQL Server - C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server) - EngISV<\/title>\n<meta name=\"description\" content=\"Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. Enable Encrypted Connection to SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.engisv.info\/?p=5253\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Micrsoft SQL Server - C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server) - EngISV\" \/>\n<meta property=\"og:description\" content=\"Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. Enable Encrypted Connection to SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=5253\" \/>\n<meta property=\"og:site_name\" content=\"EngISV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/engisv\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T16:22:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-15T16:57:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"568\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"hoanghiepktv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hoanghiepktv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"Micrsoft SQL Server &#8211; C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server)\",\"datePublished\":\"2023-07-15T16:22:55+00:00\",\"dateModified\":\"2023-07-15T16:57:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253\"},\"wordCount\":739,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"keywords\":[\"Certificate\",\"Microsoft SQL Server\"],\"articleSection\":[\"Database\",\"Ki\u1ebfn th\u1ee9c\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253\",\"name\":\"Micrsoft SQL Server - C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server) - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"datePublished\":\"2023-07-15T16:22:55+00:00\",\"dateModified\":\"2023-07-15T16:57:05+00:00\",\"description\":\"Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\\\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\\\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. Enable Encrypted Connection to SQL Server\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=5253\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#primaryimage\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"width\":768,\"height\":568},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5253#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Micrsoft SQL Server &#8211; C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"name\":\"EngISV\",\"description\":\"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.engisv.info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\",\"name\":\"EngISV\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"width\":200,\"height\":76,\"caption\":\"EngISV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/engisv\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\",\"name\":\"hoanghiepktv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"caption\":\"hoanghiepktv\"},\"url\":\"https:\\\/\\\/www.engisv.info\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Micrsoft SQL Server - C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server) - EngISV","description":"Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. Enable Encrypted Connection to SQL Server","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:\/\/www.engisv.info\/?p=5253","og_locale":"en_US","og_type":"article","og_title":"Micrsoft SQL Server - C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server) - EngISV","og_description":"Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. Enable Encrypted Connection to SQL Server","og_url":"https:\/\/www.engisv.info\/?p=5253","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2023-07-15T16:22:55+00:00","article_modified_time":"2023-07-15T16:57:05+00:00","og_image":[{"width":768,"height":568,"url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","type":"image\/jpeg"}],"author":"hoanghiepktv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hoanghiepktv","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=5253#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=5253"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"Micrsoft SQL Server &#8211; C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server)","datePublished":"2023-07-15T16:22:55+00:00","dateModified":"2023-07-15T16:57:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=5253"},"wordCount":739,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=5253#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","keywords":["Certificate","Microsoft SQL Server"],"articleSection":["Database","Ki\u1ebfn th\u1ee9c"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=5253","url":"https:\/\/www.engisv.info\/?p=5253","name":"Micrsoft SQL Server - C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server) - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=5253#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=5253#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","datePublished":"2023-07-15T16:22:55+00:00","dateModified":"2023-07-15T16:57:05+00:00","description":"Microsoft SQL server h\u1ed7 tr\u1ee3 giao th\u1ee9c TLS\/SSL s\u1eed d\u1ee5ng certificate \u0111\u1ec3 m\u00e3 ho\u00e1 th\u00f4ng tin khi truy\u1ec1n nh\u1eadn d\u1eef li\u1ec7u gi\u1eefa Server v\u00e0 Client\/Application \u0111\u1ec3 t\u0103ng c\u01b0\u1eddng b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u. Enable Encrypted Connection to SQL Server","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=5253#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=5253"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=5253#primaryimage","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","width":768,"height":568},{"@type":"BreadcrumbList","@id":"https:\/\/www.engisv.info\/?p=5253#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"Micrsoft SQL Server &#8211; C\u1ea5u h\u00ecnh m\u00e3 ho\u00e1 cho k\u1ebft n\u1ed1i SQL Server (Enable Encrypted Connection to SQL Server)"}]},{"@type":"WebSite","@id":"https:\/\/www.engisv.info\/#website","url":"https:\/\/www.engisv.info\/","name":"EngISV","description":"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!","publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.engisv.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.engisv.info\/#organization","name":"EngISV","url":"https:\/\/www.engisv.info\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","width":200,"height":76,"caption":"EngISV"},"image":{"@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/engisv"]},{"@type":"Person","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf","name":"hoanghiepktv","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","caption":"hoanghiepktv"},"url":"https:\/\/www.engisv.info\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/5253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5253"}],"version-history":[{"count":3,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/5253\/revisions"}],"predecessor-version":[{"id":5298,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/5253\/revisions\/5298"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/media\/4404"}],"wp:attachment":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}