{"id":2384,"date":"2020-07-07T13:58:05","date_gmt":"2020-07-07T13:58:05","guid":{"rendered":"https:\/\/www.tiagoneves.net\/blog\/?p=2384"},"modified":"2020-07-07T14:10:55","modified_gmt":"2020-07-07T14:10:55","slug":"conectando-no-sql-server-utilizando-o-credencial-do-windows","status":"publish","type":"post","link":"https:\/\/www.tiagoneves.net\/blog\/conectando-no-sql-server-utilizando-o-credencial-do-windows\/","title":{"rendered":"Conectando no SQL Server utilizando Credencial do Windows"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ol\u00e1 pessoal, tudo certo?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">No post de hoje vou compartilhar um caso do dia-a-dia que tive que atender e achei bem interessante.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Como muitos sabem, neste momento obscuro da humanidade causado pelo <strong>COVID-19<\/strong>, muitas empresas tem implementado a rotina de trabalho <strong>home-office<\/strong>, o que creio que ser\u00e1 o futuro de muitas empresas, mesmo quando essa pandemia acabar.<\/p>\n\n\n\n<p style=\"font-size:25px\" class=\"has-text-color has-vivid-cyan-blue-color wp-block-paragraph\"><strong><em>Entendendo o cen\u00e1rio:<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Uma das empresas que atendo implementou a rotina de trabalho <strong>home-office<\/strong>. Com isso, foi solicitado que as pessoas que precisam acessar o banco de dados continuem utilizando o <strong>m\u00e9todo de autentica\u00e7\u00e3o<\/strong> <strong>\u201cWindows Authentication\u201d<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Os <strong>desenvolvedores<\/strong> fazem o <strong>acesso<\/strong> da seguinte forma:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Utilizam os seus <strong>computadores pessoais<\/strong>;<\/li><li>Conectam na <strong>VPN<\/strong> da empresa;<\/li><li>Conectam diretamente no <strong>servidor<\/strong> utilizando um <strong>Remote Desktop;<\/strong><\/li><li>Por fim, acessam o banco de dados usando o SSMS com a <strong>autentica\u00e7\u00e3o<\/strong> <strong>\u201cWindows Authentication\u201d<\/strong>.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">O <strong>cen\u00e1rio desejado<\/strong> para os <strong>desenvolvedores<\/strong> \u00e9:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Que eles <strong>parem<\/strong> de utilizar o <strong>Remote Desktop <\/strong>para acessar diretamente o servidor;<\/li><li>Passem a <strong>utilizar<\/strong> o seu pr\u00f3prio <strong>computador pessoal <\/strong>para acessar o banco de dados via <strong>SSMS<\/strong> (SQL Server Management Studio). Entretanto, eles ainda precisam utilizar a <strong>autentica\u00e7\u00e3o<\/strong> <strong>\u201cWindows Authentication\u201d<\/strong>.<\/li><\/ul>\n\n\n\n<p style=\"font-size:25px\" class=\"has-text-color has-vivid-cyan-blue-color wp-block-paragraph\"><strong><em>Solu\u00e7\u00e3o:<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pensei em algumas <strong>solu\u00e7\u00f5es poss\u00edveis<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Publicar somente o SSMS no Remote Desktop, mas isso n\u00e3o atenderia \u00e0 solicita\u00e7\u00e3o do cliente, pois eles continuariam utilizando o Remote Desktop; (solu\u00e7\u00e3o descartada)<\/li><li>Outra solu\u00e7\u00e3o pensada foi utilizar o <strong>AD Azure<\/strong>, mas tamb\u00e9m demandaria tempo e custo; (solu\u00e7\u00e3o descartada)<\/li><li>Por fim, trocando uma ideia com o <strong><em><a href=\"https:\/\/www.linkedin.com\/in\/wiluey-sousa-0829bb51\/\" target=\"_blank\" rel=\"noreferrer noopener\">Wiluey Sousa<\/a><\/em><\/strong>, ele sugeriu <strong>criar as credenciais<\/strong> no <strong>Cofre de Credenciais do Windows<\/strong>. (solu\u00e7\u00e3o utilizada!)<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Agora vou mostrar um passo a passo de como podemos fazer isso!<\/p>\n\n\n\n<h4 class=\"has-vivid-cyan-blue-color has-text-color wp-block-heading\"><strong><em>Step-by-Step:<\/em><\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Em primeiro lugar, vamos abrir o <strong>\u201cControl Panel\u201d<\/strong> e pesquisar por <strong>\u201ccredential\u201d<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"157\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-001.png?resize=678%2C157&#038;ssl=1\" alt=\"\" class=\"wp-image-2385\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-001.png?resize=1024%2C237&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-001.png?resize=300%2C70&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-001.png?resize=768%2C178&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-001.png?w=1126&amp;ssl=1 1126w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">No <strong>\u201cCredential Manager\u201d<\/strong>, selecione o <strong>\u201cWindows Credentials\u201d -\u00e0 \u201cAdd a Windows credential\u201d<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"512\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-002.png?resize=609%2C512&#038;ssl=1\" alt=\"\" class=\"wp-image-2386\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-002.png?w=609&amp;ssl=1 609w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-002.png?resize=300%2C252&amp;ssl=1 300w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Nas <strong>credenciais<\/strong>, devemos cria-la utilizando o <strong>Endere\u00e7o IP<\/strong>. Se voc\u00ea preferir utilizar o <strong>FQDN<\/strong>, ser\u00e1 necess\u00e1rio <strong>adicionar uma entrada no Registro do Host do Windows<\/strong>. Agora vou mostrar como podemos fazer essas duas configura\u00e7\u00f5es. Vamos l\u00e1!<\/p>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-vivid-cyan-blue-color wp-block-paragraph\"><strong><em>Criando a credencial utilizando o Endere\u00e7o IP:<\/em><\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"249\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-003.png?resize=611%2C249&#038;ssl=1\" alt=\"\" class=\"wp-image-2387\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-003.png?w=611&amp;ssl=1 611w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-003.png?resize=300%2C122&amp;ssl=1 300w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Internet or network address \u2013<\/strong> <strong>Nome do Servidor ou Endere\u00e7o IP<\/strong> a ser utilizado. Um ponto <strong>muito importante<\/strong> \u00e9 informar a <strong>PORTA<\/strong> do <strong>servi\u00e7o do SQL Server<\/strong>. No meu caso, estou utilizando a porta <strong>1433 <\/strong>(porta padr\u00e3o do SQL Server).<\/li><li><strong>User Name \u2013<\/strong> Informar o <strong>Nome do Usu\u00e1rio<\/strong> que voc\u00ea vai utilizar para se <strong>autenticar no AD<\/strong>.<\/li><li><strong>Password \u2013<\/strong> Informar a <strong>Senha do Usu\u00e1rio<\/strong>. Um <strong>ponto de aten\u00e7\u00e3o<\/strong> \u00e9 que se voc\u00ea digitar a <strong>senha errada ele n\u00e3o vai dar erro<\/strong> para criar a credencial, por\u00e9m ao tentar se autenticar no SQL Server vai dar erro.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ao <strong>criar a credencial<\/strong>, n\u00f3s estamos <strong>vinculando<\/strong> o nosso <strong>usu\u00e1rio local<\/strong> com o <strong>usu\u00e1rio do servidor (Windows Authentication)<\/strong>, como se estiv\u00e9ssemos utilizando o <strong>Remote Desktop<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Depois disso, no <strong>SSMS<\/strong> devemos <strong>informar o IP<\/strong> e selecionar o <strong>\u201cWindows Authentication\u201d<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"384\" height=\"256\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/image.png?resize=384%2C256&#038;ssl=1\" alt=\"\" class=\"wp-image-2388\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/image.png?w=384&amp;ssl=1 384w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/image.png?resize=300%2C200&amp;ssl=1 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Mesmo utilizando o <strong>\u201cUser Name\u201d<\/strong> com o nome do seu <strong>usu\u00e1rio local<\/strong>, na verdade voc\u00ea vai se conectar no banco de dados utilizando a <strong>credencial no AD<\/strong> que voc\u00ea criou anteriormente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ap\u00f3s conseguir conectar no banco de dados, podemos fazer um teste e visualizar as sess\u00f5es utilizando o script abaixo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT conn.session_id, host_name, program_name,\n    nt_domain, login_name, connect_time, last_request_end_time \nFROM sys.dm_exec_sessions AS sess\nJOIN sys.dm_exec_connections AS conn\n   ON sess.session_id = conn.session_id;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Como podemos ver, o <strong>\u201clogin_name\u201d<\/strong> est\u00e1 utilizando o <strong>usu\u00e1rio do dom\u00ednio<\/strong> ao inv\u00e9s do <strong>usu\u00e1rio local <\/strong>que tinha aparecido na tela de conex\u00e3o do SSMS! <strong>Show, conseguimos!!!<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"124\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-005.png?resize=678%2C124&#038;ssl=1\" alt=\"\" class=\"wp-image-2389\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-005.png?w=1023&amp;ssl=1 1023w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-005.png?resize=300%2C55&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-005.png?resize=768%2C140&amp;ssl=1 768w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-vivid-cyan-blue-color wp-block-paragraph\"><strong><em>Criando a credencial utilizando o FQDN:<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"184\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-004.png?resize=560%2C184&#038;ssl=1\" alt=\"\" class=\"wp-image-2391\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-004.png?w=560&amp;ssl=1 560w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-004.png?resize=300%2C99&amp;ssl=1 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As informa\u00e7\u00f5es s\u00e3o as mesmas da configura\u00e7\u00e3o utilizando o IP, a \u00fanica diferen\u00e7a \u00e9 que agora voc\u00ea dever\u00e1 colocar o <strong>nome do DNS<\/strong>, mantendo a porta tamb\u00e9m.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"542\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-007-1.png?resize=678%2C542&#038;ssl=1\" alt=\"\" class=\"wp-image-2392\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-007-1.png?w=692&amp;ssl=1 692w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-007-1.png?resize=300%2C240&amp;ssl=1 300w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Para conectar no SSMS \u00e9 <strong>necess\u00e1rio<\/strong> <strong>adicionar as entradas<\/strong> na <strong>tabela de hosts do Windows<\/strong> \u201c<em><span style=\"text-decoration: underline;\">C:\\Windows\\System32\\drivers\\etc\\hosts<\/span><\/em>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"426\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-008.png?resize=678%2C426&#038;ssl=1\" alt=\"\" class=\"wp-image-2393\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-008.png?w=917&amp;ssl=1 917w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-008.png?resize=300%2C188&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-008.png?resize=768%2C482&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-008.png?resize=200%2C125&amp;ssl=1 200w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ap\u00f3s adicionar as entradas na tabela de hosts, basta conectar no SSMS normalmente.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"353\" height=\"234\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/image-1.png?resize=353%2C234&#038;ssl=1\" alt=\"\" class=\"wp-image-2394\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/image-1.png?w=353&amp;ssl=1 353w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/image-1.png?resize=300%2C199&amp;ssl=1 300w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"199\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-009-1.png?resize=345%2C199&#038;ssl=1\" alt=\"\" class=\"wp-image-2397\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-009-1.png?w=345&amp;ssl=1 345w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-009-1.png?resize=300%2C173&amp;ssl=1 300w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/figure><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code> SELECT conn.session_id, host_name, program_name,\n    nt_domain, login_name, connect_time, last_request_end_time \nFROM sys.dm_exec_sessions AS sess\nJOIN sys.dm_exec_connections AS conn\n   ON sess.session_id = conn.session_id;<\/code><\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1728\" height=\"438\" src=\"https:\/\/i1.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?fit=678%2C172&amp;ssl=1\" alt=\"\" class=\"wp-image-2395\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?w=1728&amp;ssl=1 1728w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?resize=300%2C76&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?resize=1024%2C260&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?resize=768%2C195&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?resize=1536%2C389&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/Conect_Windows_Authentication_Windows_Credential-010.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Essa foi a solu\u00e7\u00e3o implementada no cliente! Espero que se voc\u00eas passarem por uma necessidade deste tipo, essa solu\u00e7\u00e3o tamb\u00e9m possa ser \u00fatil.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bom pessoal por hoje \u00e9 isso.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Abra\u00e7os,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tiago Neves<\/p>\n","protected":false},"excerpt":{"rendered":"<p>J\u00e1 pensou em usar o tipo de conex\u00e3o &#8220;Windows Authentication&#8221;, em uma esta\u00e7\u00e3o de trabalho fora do dom\u00ednio?<br \/>\nNeste post mostro como podemos configurar essa funcionalidade do Windows. <\/p>\n","protected":false},"author":1,"featured_media":2398,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_91251433_91251433":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"J\u00e1 pensou em usar o tipo de conex\u00e3o \"Windows Authentication\", em uma esta\u00e7\u00e3o de trabalho fora do dom\u00ednio?\nNeste post mostro como podemos configurar essa funcionalidade do Windows. ","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_wpscppro_dont_share_socialmedia":false,"_wpscppro_custom_social_share_image":0,"_facebook_share_type":"","_twitter_share_type":"","_linkedin_share_type":"","_pinterest_share_type":"","_linkedin_share_type_page":"","_instagram_share_type":"","_medium_share_type":"","_threads_share_type":"","_google_business_share_type":"","_selected_social_profile":[],"_wpsp_enable_custom_social_template":false,"_wpsp_social_scheduling":{"enabled":false,"datetime":null,"platforms":[],"status":"template_only","dateOption":"today","timeOption":"now","customDays":"","customHours":"","customDate":"","customTime":"","schedulingType":"absolute"},"_wpsp_active_default_template":true},"categories":[2,220,16,26,20],"tags":[315,127,317,65,35,119,116,316,21,318,314],"class_list":["post-2384","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-casos-do-dia-a-dia","category-sql-server-2017","category-sqlserver-2014","category-sqlserver-2016","category-sqlserver-geral","tag-credencial-do-windows","tag-dbasqlserver","tag-remote-desktop","tag-seguranca","tag-sql-server","tag-tiagodba","tag-tiagonevesdba","tag-vpn","tag-windows-authentication","tag-windows-authentication-without-domain","tag-windows-credential"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/07\/81-813277_windows-10-user-icon-svg-hd-png-download.png?fit=860%2C847&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6eIyh-Cs","jetpack-related-posts":[{"id":89,"url":"https:\/\/www.tiagoneves.net\/blog\/alterando-o-tipo-autenticacao-do-sqlserver\/","url_meta":{"origin":2384,"position":0},"title":"Alterando o tipo autentica\u00e7\u00e3o do SQLServer","author":"tiagoneves","date":"10 de maio de 2015","format":false,"excerpt":"Ol\u00e1 pessoal tudo certo? Hoje vou postar sobre um erro que aconteceu comigo e perdi um tempo para encontrar o problema. O erro \u00e9 quando voc\u00ea vai logar com\u00a0usu\u00e1rio de SQL e aparece o erro \u201clogin failed for user: <nome_user>\u201d. Tentei de tudo para logar, troquei\u00a0a senha do usu\u00e1rio, testei\u2026","rel":"","context":"Em &quot;Scripts&quot;","block_context":{"text":"Scripts","link":"https:\/\/www.tiagoneves.net\/blog\/category\/scripts\/"},"img":{"alt_text":"1","src":"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/18.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/18.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/18.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":468,"url":"https:\/\/www.tiagoneves.net\/blog\/atualizando-o-windows-server-de-um-cluster-sql-server\/","url_meta":{"origin":2384,"position":1},"title":"Atualizando o Windows Server de um Cluster SQL Server","author":"tiagoneves","date":"24 de fevereiro de 2016","format":false,"excerpt":"Ol\u00e1 pessoal tudo certo? No post de hoje vou comentar e demonstrar uma migra\u00e7\u00e3o de sistema operacional de um Cluster SQL Server que fiz essa semana. Cen\u00e1rio: Na empresa que trabalho tem um cluster SQL Server ativo\/passivo, nele tem 10 inst\u00e2ncias SQL Server 2008 R2 instaladas e os servidores eram\u2026","rel":"","context":"Em &quot;Casos do dia-a-dia&quot;","block_context":{"text":"Casos do dia-a-dia","link":"https:\/\/www.tiagoneves.net\/blog\/category\/casos-do-dia-a-dia\/"},"img":{"alt_text":"Windows_Cluster_Single_Node","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/02\/Windows_Cluster_Single_Node.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/02\/Windows_Cluster_Single_Node.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/02\/Windows_Cluster_Single_Node.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/02\/Windows_Cluster_Single_Node.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/02\/Windows_Cluster_Single_Node.png?resize=1050%2C600 3x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/02\/Windows_Cluster_Single_Node.png?resize=1400%2C800 4x"},"classes":[]},{"id":62,"url":"https:\/\/www.tiagoneves.net\/blog\/instalando-o-microsoft-sqlserver-2014\/","url_meta":{"origin":2384,"position":2},"title":"Instalando o Microsoft SQLServer 2014","author":"tiagoneves","date":"6 de maio de 2015","format":false,"excerpt":"Ol\u00e1 pessoal tudo certo? No post dessa semana vou escrever sobre como fazer a instala\u00e7\u00e3o do SQLServer 2014, por mais que pare\u00e7a simples, vejo muitas pessoas postando duvidas sobre como fazer a instala\u00e7\u00e3o nos f\u00f3runs. Antes de iniciar a instala\u00e7\u00e3o recomendo dar uma lida na documenta\u00e7\u00e3o da Microsoft sobre os\u2026","rel":"","context":"Em &quot;SQLServer 2014&quot;","block_context":{"text":"SQLServer 2014","link":"https:\/\/www.tiagoneves.net\/blog\/category\/sqlserver-2014\/"},"img":{"alt_text":"1","src":"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":1257,"url":"https:\/\/www.tiagoneves.net\/blog\/como-criar-uma-vm-com-o-sql-server-2017-no-azure\/","url_meta":{"origin":2384,"position":3},"title":"Como criar uma VM com o SQL Server 2017 no Azure","author":"tiagoneves","date":"6 de fevereiro de 2018","format":false,"excerpt":"Ol\u00e1 pessoal tudo certo? No post de hoje vou demonstrar como criar uma Maquina Virtual (VM) com o SQL Server 2017 no Azure. Conforme falamos no \u00faltimo post, o SQL Server 2017 \u00e9 compat\u00edvel com o Windows Server e Linux. Quando vamos criar uma VM no Azure podemos escolher qual\u2026","rel":"","context":"Em &quot;Azure&quot;","block_context":{"text":"Azure","link":"https:\/\/www.tiagoneves.net\/blog\/category\/azure\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/02\/Create_VM_SQLServer2017_SSMS.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2269,"url":"https:\/\/www.tiagoneves.net\/blog\/leitura-na-replica-do-alwayson-com-sql-standard-isso-e-possivel-parte-i\/","url_meta":{"origin":2384,"position":4},"title":"Leitura na R\u00e9plica do AlwaysOn com SQL Standard? Isso \u00e9 poss\u00edvel? &#8211; Parte I","author":"tiagoneves","date":"5 de fevereiro de 2020","format":false,"excerpt":"Ol\u00e1 pessoal tudo certo? Estamos iniciando mais um ano de atividade aqui no blog, neste primeiro post vou compartilhar uma solu\u00e7\u00e3o de contorno que desenhei em um cliente. Cen\u00e1rio: O cliente estava tendo v\u00e1rios problemas de performance no SQL Server, pois no ambiente dele tinha v\u00e1rias requisi\u00e7\u00f5es de relat\u00f3rios, al\u00e9m\u2026","rel":"","context":"Em &quot;Casos do dia-a-dia&quot;","block_context":{"text":"Casos do dia-a-dia","link":"https:\/\/www.tiagoneves.net\/blog\/category\/casos-do-dia-a-dia\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/02\/AlwaysOn_Snapshot001.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/02\/AlwaysOn_Snapshot001.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/02\/AlwaysOn_Snapshot001.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/02\/AlwaysOn_Snapshot001.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/02\/AlwaysOn_Snapshot001.png?resize=1050%2C600 3x"},"classes":[]},{"id":1840,"url":"https:\/\/www.tiagoneves.net\/blog\/o-suporte-do-sql-server-2008-chegou-ao-fim-e-agora\/","url_meta":{"origin":2384,"position":5},"title":"O suporte do SQL Server 2008 chegou ao fim. E agora?","author":"tiagoneves","date":"11 de julho de 2019","format":false,"excerpt":"Ol\u00e1 pessoal, Existem datas que nunca acreditamos que vai chegar, ou s\u00e3o datas t\u00e3o, t\u00e3o, t\u00e3o distante que acabamos nos esquecendo e n\u00e3o nos preparamos para ela. Ent\u00e3o o dia 09 de Julho de 2019 chegou e com ele o fim do suporte do SQL Server 2008, voc\u00ea se preparou\u2026","rel":"","context":"Em &quot;SQL Server 2008&quot;","block_context":{"text":"SQL Server 2008","link":"https:\/\/www.tiagoneves.net\/blog\/category\/sql-server-2008\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Risk.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Risk.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Risk.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Risk.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Risk.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Risk.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/2384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/comments?post=2384"}],"version-history":[{"count":3,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/2384\/revisions"}],"predecessor-version":[{"id":2401,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/2384\/revisions\/2401"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media\/2398"}],"wp:attachment":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media?parent=2384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/categories?post=2384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/tags?post=2384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}