{"id":4982,"date":"2021-06-27T17:21:02","date_gmt":"2021-06-27T10:21:02","guid":{"rendered":"https:\/\/www.engisv.info\/?p=4982"},"modified":"2021-06-27T17:25:52","modified_gmt":"2021-06-27T10:25:52","slug":"sql-server-authentication","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=4982","title":{"rendered":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server &#8211; SQL Server authentication"},"content":{"rendered":"<p>Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication.<\/p>\n<p>SQL Server authentication, s\u1eed d\u1ee5ng user tr\u00ean SQL Server \u0111\u1ec3 ch\u1ee9ng th\u1ef1c, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>M\u1ea1ng c\u1ee7a b\u1ea1n l\u00e0 m\u1ea1ng Workgroup, c\u00e1c m\u00e1y kh\u00f4ng join c\u00f9ng domain controller.<\/li>\n<li>C\u00e1c h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u1ee7a c\u00e1c m\u00e1y SQL server, Application, Web v\u00e0 SQL Client thu\u1ed9c c\u00e1c n\u1ec1n t\u1ea3n kh\u00e1ch nhau. V\u00ed d\u1ee5:\n<ul>\n<li>B\u1ea1n <a href=\"https:\/\/www.engisv.info\/?s=%22sql+server%22+%22centos%22\" target=\"_blank\" rel=\"noopener\">tri\u1ec3n khai m\u1ed9t SQL Server tr\u00ean CentOS<\/a>, nh\u01b0ng Application ho\u1eb7c Web Application l\u1ea1i l\u00e0 m\u00e1y Windows.<\/li>\n<li>B\u1ea1n truy c\u1eadp <a href=\"https:\/\/www.engisv.info\/?p=2183\" target=\"_blank\" rel=\"noopener\">SQL Server \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y Windows<\/a> khi \u0111ang s\u1eed d\u1ee5ng MacOS, CentOS&#8230;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4984 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQLauthentication.png\" alt=\"\" width=\"534\" height=\"374\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQLauthentication.png 501w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQLauthentication-300x210.png 300w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/p>\n<p>\u0110\u1ec3 t\u1ea1o t\u00e0i kho\u1ea3n ch\u1ee9ng th\u1ef1c tr\u00ean SQL server, ban ti\u1ebfn h\u00e0nh nh\u01b0 sau:<\/p>\n<p>Trong m\u1ee5c <strong>Security<\/strong> &gt;<strong> Logins<\/strong>, ch\u1ecdn <strong>New Login&#8230;<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-4986 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-1-300x263.png\" alt=\"\" width=\"300\" height=\"263\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-1-300x263.png 300w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-1.png 306w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Ti\u1ebfp theo, t\u1ea1i m\u1ee5c <strong>General<\/strong>:<\/p>\n<ul>\n<li>(4) \u0110\u1eb7t t\u00ean t\u00e0i kho\u1ea3n login<\/li>\n<li>(5) Ch\u1ecdn ki\u1ec3u ch\u1ee9ng th\u1ef1c l\u00e0 <strong>SQL Server authentication<\/strong> v\u00e0 \u0111\u1eb7t password cho t\u00e0i kho\u1ea3n.<\/li>\n<li>(6) Th\u1ef1c hi\u1ec7n c\u00e1c ch\u00ednh s\u00e1ch password cho t\u00e0i kho\u1ea3n, c\u00e1c t\u00f9y ch\u1ecdn n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ho\u1eb7c kh\u00f4ng ch\u1ecdn, t\u00f9y theo nhu c\u1ea7u c\u1ee7a m\u00ecnh:\n<ul>\n<li><strong>Enforece Password Policy<\/strong> v\u00e0 <strong>Enforce password<\/strong>: Hai m\u1ee5c n\u00e0y s\u1ebd s\u1eed d\u1ee5ng ch\u00ednh s\u00e1ch c\u1ee7a <a style=\"background-color: #ffffff;\" href=\"https:\/\/www.engisv.info\/?p=362\" target=\"_blank\" rel=\"noopener\">Computer Configuration -&gt; Windows Settings -&gt; Security Settings -&gt; Account Policies<\/a><\/li>\n<li><strong>User must change password at next login<\/strong>: V\u1edbi t\u00f9y ch\u1ecdn n\u00e0y, user s\u1ebd ph\u1ea3i \u0111\u1ed5i password l\u1ea1i khi th\u1ef1c hi\u1ec7n \u0111\u0103ng nh\u1eadp l\u1ea7n ti\u1ebfp theo.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4995 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-2.png\" alt=\"\" width=\"519\" height=\"429\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-2.png 700w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-2-300x248.png 300w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><\/p>\n<p>Ti\u1ebfp theo, \u1edf m\u1ee5c <strong>Server Roles<\/strong>, b\u1ea1n <a href=\"https:\/\/www.engisv.info\/?p=4938\" target=\"_blank\" rel=\"noopener\">ti\u1ebfn h\u00e0nh ch\u1ecdn c\u00e1c server roles<\/a> theo y\u00eau c\u1ea7u s\u1eed d\u1ee5ng c\u1ee7a user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4988 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-3.png\" alt=\"\" width=\"525\" height=\"438\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-3.png 696w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-3-300x250.png 300w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>Ti\u1ebfp theo, trong m\u1ee5c <strong>User Mapping<\/strong>:<\/p>\n<ul>\n<li>(10) Ch\u1ecdn database m\u00e0 user \u0111\u01b0\u1ee3c ph\u00e9p c\u1ea5p quy\u1ec1n truy c\u1eadp.<\/li>\n<li>(11) Ch\u1ecdn <a href=\"https:\/\/www.engisv.info\/?p=4938\" target=\"_blank\" rel=\"noopener\">quy\u1ec1n\u00a0 m\u00e0 user s\u1ebd \u0111\u01b0\u1ee3c c\u1ea5p tr\u00ean database<\/a><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4989 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-4.png\" alt=\"\" width=\"537\" height=\"445\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-4.png 695w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-4-300x249.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/p>\n<p>\u1ede m\u1ee5c <strong>Status<\/strong>, b\u1ea1n ch\u1eafc ch\u1eafn user \u1edf tr\u1ea1ng th\u00e1i nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi v\u00e0 b\u1ea5m<strong> OK<\/strong> \u0111\u1ec3 k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4990 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-5.png\" alt=\"\" width=\"509\" height=\"420\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-5.png 694w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-5-300x247.png 300w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/p>\n<p>Sau khi t\u1ea1o v\u00e0 c\u1ea5p quy\u1ec1n xong, b\u1ea1n s\u1ebd th\u1ea5y trong m\u1ee5c <strong>Security <\/strong>&gt;<strong> Logins<\/strong> s\u1ebd th\u1ea5y user v\u1eeba t\u1ea1o ra.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4991 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-6.png\" alt=\"\" width=\"381\" height=\"328\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-6.png 381w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-6-300x258.png 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/p>\n<p>T\u1eeb Client, b\u1ea1n d\u00f9ng SSMS \u0111\u1ec3 truy c\u1eadp \u0111\u1ebfn SQL server v\u1edbi t\u00e0i kho\u1ea3n v\u1eeba t\u1ea1o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4992 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-7.png\" alt=\"\" width=\"539\" height=\"347\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-7.png 730w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-7-300x193.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<p>Do ch\u1ecdn m\u1ee5c <strong>User must change password at next login<\/strong> khi t\u1ea1o user \u1edf tr\u00ean, n\u00ean b\u1ea1n s\u1ebd ti\u1ebfn h\u00e0ng thay \u0111\u1ed5i password c\u1ee7a t\u00e0i kho\u1ea3n ngay l\u1ea7n \u0111\u0103ng nh\u1eadp \u0111\u1ea7u ti\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4993 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-8.png\" alt=\"\" width=\"405\" height=\"264\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-8.png 478w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-8-300x195.png 300w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/p>\n<p>Sau khi \u0111\u1ed5i password, v\u00e0 \u0111\u0103ng nh\u1eadp th\u00e0nh c\u00f4ng, b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y nh\u1eefng g\u00ec m\u00e0 user \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4994 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-9.png\" alt=\"\" width=\"276\" height=\"304\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-9.png 427w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/06\/SQL_authen_user-9-273x300.png 273w\" sizes=\"auto, (max-width: 276px) 100vw, 276px\" \/><\/p>\n<p>Tr\u00ean \u0111\u00e2y, ch\u00fang ta \u0111\u00e3 l\u00e0m quen v\u1edbi vi\u1ec7c t\u1ea1o t\u00e0i kho\u1ea3n cho mode SQL Server authentication tr\u00ean Microsoft SQL Server. V\u00e0 \u0111\u01b0\u1ee3c gi\u1eddi thi\u1ec7u vi\u1ec7c \u00e1p d\u1ee5ng mode n\u00e0y trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. SQL Server authentication, s\u1eed d\u1ee5ng user tr\u00ean SQL Server \u0111\u1ec3 ch\u1ee9ng th\u1ef1c, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng nh\u01b0: M\u1ea1ng c\u1ee7a b\u1ea1n l\u00e0 m\u1ea1ng Workgroup, c\u00e1c m\u00e1y kh\u00f4ng join c\u00f9ng domain controller. C\u00e1c h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u1ee7a c\u00e1c m\u00e1y&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":[31,50],"class_list":["post-4982","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-kien-thuc","tag-centos","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>T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server - SQL Server authentication - EngISV<\/title>\n<meta name=\"description\" content=\"Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. T\u1ea1o t\u00e0i kho\u1ea3n SQL Server authentication\" \/>\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=4982\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server - SQL Server authentication - EngISV\" \/>\n<meta property=\"og:description\" content=\"Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. T\u1ea1o t\u00e0i kho\u1ea3n SQL Server authentication\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=4982\" \/>\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=\"2021-06-27T10:21:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-27T10:25:52+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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server &#8211; SQL Server authentication\",\"datePublished\":\"2021-06-27T10:21:02+00:00\",\"dateModified\":\"2021-06-27T10:25:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982\"},\"wordCount\":681,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"keywords\":[\"CentOS\",\"Microsoft SQL Server\"],\"articleSection\":[\"Database\",\"Ki\u1ebfn th\u1ee9c\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982\",\"name\":\"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server - SQL Server authentication - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"datePublished\":\"2021-06-27T10:21:02+00:00\",\"dateModified\":\"2021-06-27T10:25:52+00:00\",\"description\":\"Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. T\u1ea1o t\u00e0i kho\u1ea3n SQL Server authentication\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=4982\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=4982#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=4982#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server &#8211; SQL Server authentication\"}]},{\"@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":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server - SQL Server authentication - EngISV","description":"Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. T\u1ea1o t\u00e0i kho\u1ea3n SQL Server authentication","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=4982","og_locale":"en_US","og_type":"article","og_title":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server - SQL Server authentication - EngISV","og_description":"Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. T\u1ea1o t\u00e0i kho\u1ea3n SQL Server authentication","og_url":"https:\/\/www.engisv.info\/?p=4982","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2021-06-27T10:21:02+00:00","article_modified_time":"2021-06-27T10:25:52+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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=4982#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=4982"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server &#8211; SQL Server authentication","datePublished":"2021-06-27T10:21:02+00:00","dateModified":"2021-06-27T10:25:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=4982"},"wordCount":681,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=4982#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","keywords":["CentOS","Microsoft SQL Server"],"articleSection":["Database","Ki\u1ebfn th\u1ee9c"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=4982","url":"https:\/\/www.engisv.info\/?p=4982","name":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server - SQL Server authentication - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=4982#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=4982#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","datePublished":"2021-06-27T10:21:02+00:00","dateModified":"2021-06-27T10:25:52+00:00","description":"Nh\u01b0 \u0111\u00e3 gi\u1edbi thi\u1ec7u trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft SQL h\u1ed7 tr\u01a1 hai ki\u1ec3u ch\u1ee9ng th\u1ef1c ng\u01b0\u1eddi d\u00f9ng l\u00e0 SQL Server user v\u00e0 Windows user (SQL Server authentication and Windows authentication). Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh t\u1ea1o m\u1ed9t t\u00e0i kho\u1ea3n SQL Server authentication. T\u1ea1o t\u00e0i kho\u1ea3n SQL Server authentication","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=4982#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=4982"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=4982#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=4982#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server &#8211; SQL Server authentication"}]},{"@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\/4982","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=4982"}],"version-history":[{"count":3,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/4982\/revisions"}],"predecessor-version":[{"id":5333,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/4982\/revisions\/5333"}],"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=4982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}