{"id":5014,"date":"2021-08-10T17:27:34","date_gmt":"2021-08-10T10:27:34","guid":{"rendered":"https:\/\/www.engisv.info\/?p=5014"},"modified":"2021-08-10T17:30:53","modified_gmt":"2021-08-10T10:30:53","slug":"sql-server-windows-authentication","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=5014","title":{"rendered":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server \u2013 Windows authentication"},"content":{"rendered":"<p>Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i <a href=\"https:\/\/www.engisv.info\/?p=4982\" target=\"_blank\" rel=\"noopener\">t\u1ea1o kho\u1ea3n login SQL server v\u1edbi mode SQL Server Authentication mode<\/a>. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows authentication. V\u1edbi Windows authentication mode c\u1ee7a SQL server, n\u00f3 c\u00f2n \u0111\u01b0\u1ee3c chia ra l\u00e0m 2 th\u00e0nh ph\u1ea7n:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.engisv.info\/?p=81\" target=\"_blank\" rel=\"noopener\"><strong>Local User<\/strong><\/a>: l\u00e0 user \u0111\u01b0\u1ee3c t\u1ea1o tr\u00ean ch\u00ednh m\u00e1y c\u00e0i SQL Server.<\/li>\n<li><a href=\"https:\/\/www.engisv.info\/?p=3868\" target=\"_blank\" rel=\"noopener\"><strong>Domain User<\/strong><\/a>: l\u00e0 user \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd t\u1eadp trung t\u1ea1i tr\u00ean Domian Controller.<\/li>\n<\/ul>\n<p>N\u1ebfu b\u1ea1n c\u00e0i SQL server tr\u00ean h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows th\u00ec m\u1eb7c \u0111\u1ecbnh Windows Authentication Mode s\u1ebd \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t m\u1ed9t c\u00e1ch m\u1eb7c \u0111\u1ecbnh.<\/p>\n<p>Trong b\u00e0i n\u00e0y, ch\u00fang \u0111i th\u1ef1c hi\u1ec7n t\u1ea1o m\u1ed9t t\u1ea1i kho\u1ea3n m\u1edbi v\u1edbi t\u00e0i kho\u1ea3n c\u1ee7a user tr\u00ean Domain Controller. Vi\u1ec7t t\u1ea1o t\u00e0i kho\u1ea3n v\u1edbi local user n\u00f3 c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u0111\u1ed1i v\u1edbi v\u1edbi user c\u1ee7a Domain Controller. M\u1ed9 h\u00ecnh th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5017 size-full\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/SQL_Win_Authen.png\" alt=\"\" width=\"453\" height=\"425\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/SQL_Win_Authen.png 453w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/SQL_Win_Authen-300x281.png 300w\" sizes=\"auto, (max-width: 453px) 100vw, 453px\" \/><\/p>\n<p>\u0110\u1ec3 t\u1ea1o t\u00e0i kho\u1ea3n, b\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>Trong m\u1ee5c\u00a0<strong>Security<\/strong>\u00a0&gt;<strong>\u00a0Logins<\/strong>, ch\u1ecdn\u00a0<strong>New Login\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5019 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-1.png\" alt=\"\" width=\"407\" height=\"353\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-1.png 407w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-1-300x260.png 300w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>\u1ede m\u1ee5c <strong>General<\/strong>:<\/p>\n<ul>\n<li>(4) Ch\u1ecdn v\u00e0o mode <strong>Windows authentication<\/strong><\/li>\n<li>(5) Click ch\u1ecd v\u00e0o n\u00fat <strong>Search&#8230;<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5020 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-2.png\" alt=\"\" width=\"602\" height=\"493\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-2.png 700w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-2-300x246.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/p>\n<p>Ti\u1ebfp theo, \u1edf c\u1ee7a s\u1ed5 <strong>Select User or Group<\/strong>:<\/p>\n<ul>\n<li>(6) Click ch\u1ecdn n\u00fat <strong>Locations&#8230;<\/strong><\/li>\n<li>(7) B\u1ea1n ch\u1ecdn n\u01a1i m\u00e0 m\u00ecnh s\u1ebd l\u1ea5y user. \u1ede \u0111\u00e2y, c\u00f3 hai v\u1ecb tr\u00ed c\u01a1 b\u1ea1n:\n<ul>\n<li><em><strong>User tr\u00ean ch\u00ednh m\u00e1y \u0111ang c\u00e0i SQL Server<\/strong><\/em>: \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng ch\u00ednh host name (\u1edd \u0111\u00e2y l\u00e0 <strong>2019-SRV01<\/strong>) c\u1ee7a m\u00e1y \u0111ang c\u00e0i \u0111\u1eb7t SQL Server<\/li>\n<li><em><strong>User tr\u00ean domain controller<\/strong><\/em>: ch\u1ee9a trong m\u1ee5c <strong>Entrie Directory.<\/strong> Do \u1edf \u0111\u00e2y ch\u1ec9 c\u00f3 m\u1ed9t domain controller duy nh\u1ea5t, n\u00ean b\u1ea1n kh\u00f4ng c\u1ea7n ch\u1ecdn domain name. N\u1ebfu trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 nhi\u1ec1u domain controller trong h\u1ec7 th\u1ed1ng b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn user thu\u1ed9c domain controller c\u1ee5 th\u1ec3 n\u00e0o.<\/li>\n<\/ul>\n<\/li>\n<li>(8) Sau khi ch\u1ecdn <strong>Entrie Directory<\/strong>, b\u1ea1n ch\u1ecdn<strong> OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5021 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-3.png\" alt=\"\" width=\"513\" height=\"457\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-3.png 513w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-3-300x267.png 300w\" sizes=\"auto, (max-width: 513px) 100vw, 513px\" \/><\/p>\n<p>Ti\u1ebfp theo, b\u1ea1n ch\u1ecdn user c\u1ea7n \u0111\u01b0\u1ee3c add quy\u1ec1n:<\/p>\n<ul>\n<li>(9) B\u1ea1n g\u00f5 v\u00e0o user name \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o \u1edf tr\u00ean domain controller<\/li>\n<li>(10) Sau g\u00f5 t\u00ean user name \u1edf m\u1ee5c (9), b\u1ea1n ch\u1ecdn v\u00e0o n\u00fat <strong>Check Names<\/strong>. N\u1ebfu t\u00e0i kho\u1ea3n \u0111\u00fang, t\u00ean t\u00e0i kho\u1ea3n \u0111\u1ea7y \u0111\u1ea9u c\u1ee7a user s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh.<\/li>\n<li>(11) Sau khi ch\u1ecdn xong t\u1ea1i kho\u1ea3n c\u1ea7n th\u00eam v\u00e0o SQL server, b\u1ea1n ch\u1ecdn <strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5022 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-4.png\" alt=\"\" width=\"457\" height=\"254\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-4.png 457w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-4-300x167.png 300w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/p>\n<p>B\u1ea1n s\u1ebd th\u1ea5y <strong>Login name<\/strong> l\u00e0 t\u00e0i kho\u1ea3n b\u1ea1n v\u1eeba th\u00eam v\u00e0o. C\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Host name\\username<\/strong>: \u0110\u1ed1i v\u1edbi t\u00e0i kho\u1ea3n local tr\u00ean ch\u00ednh m\u00e1y c\u00e0i SQL server<\/li>\n<li><strong>Domain name\\username<\/strong>: T\u00e0i kho\u1ea3n \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb Domain Controller.<\/li>\n<\/ul>\n<p>Trong b\u00e0i vi\u00eat, n\u00e0y nh\u01b0 n\u00f3i \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, ch\u00fang ra d\u00f9ng t\u00e0i kho\u1ea3n domain. \u1ede \u0111\u00e2y, domain name \u0111\u01b0\u01a1c s\u1eed d\u1ee5ng l\u00e0 <strong>hoanghiepktv<\/strong> v\u00e0 user name l\u00e0 <strong>user01<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5023 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-5.png\" alt=\"\" width=\"611\" height=\"501\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-5.png 699w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-5-300x246.png 300w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><\/p>\n<p>Ti\u1ebfp theo, \u1edf m\u1ee5c\u00a0<strong>Server Roles<\/strong>, b\u1ea1n\u00a0<a href=\"https:\/\/www.engisv.info\/?p=4938\" target=\"_blank\" rel=\"noopener\">ti\u1ebfn h\u00e0nh ch\u1ecdn c\u00e1c server roles<\/a>\u00a0theo y\u00eau c\u1ea7u s\u1eed d\u1ee5ng c\u1ee7a user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5024 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-6.png\" alt=\"\" width=\"619\" height=\"512\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-6.png 698w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-6-300x248.png 300w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/p>\n<p>Ti\u1ebfp theo, trong m\u1ee5c\u00a0<strong>User Mapping<\/strong>:<\/p>\n<ul>\n<li>(15) Ch\u1ecdn database m\u00e0 user \u0111\u01b0\u1ee3c ph\u00e9p c\u1ea5p quy\u1ec1n truy c\u1eadp.<\/li>\n<li>(16) 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-5025 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-7.png\" alt=\"\" width=\"593\" height=\"487\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-7.png 697w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-7-300x246.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/p>\n<p>\u1ede m\u1ee5c\u00a0<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>\u00a0OK<\/strong>\u00a0\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-5026 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-8.png\" alt=\"\" width=\"570\" height=\"471\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-8.png 699w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-8-300x248.png 300w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng SQL Server, tr\u00ean m\u00e1y client b\u1ea1n logon m\u00e1y t\u00ednh b\u1eb1ng t\u00e0i kho\u1ea3n m\u00e0 \u0111\u00e3 th\u00eam v\u00e0o longin SQL server. \u1ede trong b\u00e0i vi\u1ec7c n\u00e0y l\u00e0 user01.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5027 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-9.png\" alt=\"\" width=\"476\" height=\"212\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-9.png 476w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-9-300x134.png 300w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/p>\n<p>Khi s\u1eed d\u1ee5ng Windows Authentication mode, SSMS s\u1ebd s\u1eed d\u1ee5ng ch\u00ednh t\u00e0i kho\u1ea3n \u0111ang logon v\u00e0o m\u00e1y client \u0111\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o SQL Database Engine. B\u1ea1n s\u1ebd th\u1ea5y ph\u1ea7n nh\u1eadp User nane v\u00e0 Password b\u1ecb m\u1edd \u0111i v\u00e0 User name login m\u1eb7c \u0111\u1ecbnh l\u00e0 s\u1ebd user \u0111ang logon user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5028 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-10.png\" alt=\"\" width=\"604\" height=\"437\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-10.png 604w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-10-300x217.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>Sau khi login th\u00e0nh c\u00f4ng, b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng ph\u1ea7n m\u00e0 m\u00ecnh \u0111\u01b0\u1ee3c ph\u00e2n quy\u1ec1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5029 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-11.png\" alt=\"\" width=\"475\" height=\"308\" srcset=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-11.png 475w, https:\/\/www.engisv.info\/wp-content\/uploads\/2021\/08\/Windows_authen_mode-11-300x195.png 300w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 \u0111i t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch t\u1ea1o t\u00e0i kho\u1ea3n SQL Server v\u1edbi Windows Authentication mode. \u0110\u00e2y l\u00e0 mode r\u1ea5t quan tr\u1ecdng khi d\u00f9ng SQL Server tr\u00ean m\u00f4i tr\u01b0\u1eddng Windows, n\u00f3 gi\u00fap ng\u01b0\u1eddi dung c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp m\u1ed9t l\u1ea7n v\u00e0o Windows v\u00e0 c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o SQL Server m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i th\u00eam b\u01b0\u1edbc nh\u1eadp User name v\u00e0 Password \u1edf nhu \u1edf SQL Authentication Mode. V\u1edbi Windows Authentication mode k\u1ebft h\u1ee3p v\u1edbi h\u1ec7 th\u1ed1ng Domain controller c\u1ee7a Windows s\u1ebd gi\u00fap b\u1ea1n \u0111\u01a1n gi\u1ea3n h\u00f3a vi\u1ec7c t\u1ea1o t\u00e0i kho\u1ea3n v\u00e0 ph\u00e2n quy\u1ec1n cho SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1o kho\u1ea3n login SQL server v\u1edbi mode SQL Server Authentication mode. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows authentication. V\u1edbi Windows authentication mode c\u1ee7a SQL server, n\u00f3 c\u00f2n \u0111\u01b0\u1ee3c chia ra l\u00e0m 2 th\u00e0nh ph\u1ea7n: Local User: l\u00e0 user \u0111\u01b0\u1ee3c t\u1ea1o tr\u00ean ch\u00ednh m\u00e1y c\u00e0i SQL Server. Domain User: l\u00e0 user \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd t\u1eadp trung t\u1ea1i tr\u00ean Domian Controller. N\u1ebfu b\u1ea1n c\u00e0i 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":[35,50],"class_list":["post-5014","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-kien-thuc","tag-domain-controller","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 \u2013 Windows authentication - EngISV<\/title>\n<meta name=\"description\" content=\"Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1i kho\u1ea3n login SQL server v\u1edbi mode SQL Server authentication. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows 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=5014\" \/>\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 \u2013 Windows authentication - EngISV\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1i kho\u1ea3n login SQL server v\u1edbi mode SQL Server authentication. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows authentication.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=5014\" \/>\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-08-10T10:27:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-10T10:30:53+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=5014#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server \u2013 Windows authentication\",\"datePublished\":\"2021-08-10T10:27:34+00:00\",\"dateModified\":\"2021-08-10T10:30:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014\"},\"wordCount\":996,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"keywords\":[\"Domain Controller\",\"Microsoft SQL Server\"],\"articleSection\":[\"Database\",\"Ki\u1ebfn th\u1ee9c\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014\",\"name\":\"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server \u2013 Windows authentication - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/SQL-server.jpg\",\"datePublished\":\"2021-08-10T10:27:34+00:00\",\"dateModified\":\"2021-08-10T10:30:53+00:00\",\"description\":\"Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1i kho\u1ea3n login SQL server v\u1edbi mode SQL Server authentication. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows authentication.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=5014\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=5014#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=5014#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 \u2013 Windows 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 \u2013 Windows authentication - EngISV","description":"Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1i kho\u1ea3n login SQL server v\u1edbi mode SQL Server authentication. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows 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=5014","og_locale":"en_US","og_type":"article","og_title":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server \u2013 Windows authentication - EngISV","og_description":"Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1i kho\u1ea3n login SQL server v\u1edbi mode SQL Server authentication. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows authentication.","og_url":"https:\/\/www.engisv.info\/?p=5014","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2021-08-10T10:27:34+00:00","article_modified_time":"2021-08-10T10:30:53+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=5014#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=5014"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server \u2013 Windows authentication","datePublished":"2021-08-10T10:27:34+00:00","dateModified":"2021-08-10T10:30:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=5014"},"wordCount":996,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=5014#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","keywords":["Domain Controller","Microsoft SQL Server"],"articleSection":["Database","Ki\u1ebfn th\u1ee9c"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=5014","url":"https:\/\/www.engisv.info\/?p=5014","name":"T\u1ea1o t\u00e0i kho\u1ea3n login tr\u00ean SQL Server \u2013 Windows authentication - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=5014#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=5014#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2019\/12\/SQL-server.jpg","datePublished":"2021-08-10T10:27:34+00:00","dateModified":"2021-08-10T10:30:53+00:00","description":"Trong b\u00e0y vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 l\u00e0 quen v\u1edbi vi\u1ec7c t\u1ea1i t\u1ea1i kho\u1ea3n login SQL server v\u1edbi mode SQL Server authentication. trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi vi\u1ec7c c\u1ea5u h\u00ecnh t\u1ea1o t\u00e0i kho\u1ea3n login SQL Server v\u1edbi Windows authentication.","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=5014#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=5014"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=5014#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=5014#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 \u2013 Windows 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\/5014","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=5014"}],"version-history":[{"count":2,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/5014\/revisions"}],"predecessor-version":[{"id":5038,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/5014\/revisions\/5038"}],"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=5014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}