{"id":9644,"date":"2018-11-19T08:46:33","date_gmt":"2018-11-19T10:46:33","guid":{"rendered":"http:\/\/www.fabriciolima.net\/?p=9644"},"modified":"2018-11-19T08:46:33","modified_gmt":"2018-11-19T10:46:33","slug":"managed-instance-como-se-conectar-direto-do-ssms-utilizando-uma-vpn","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2018\/11\/19\/managed-instance-como-se-conectar-direto-do-ssms-utilizando-uma-vpn\/","title":{"rendered":"Managed Instance &#8211; Como se conectar direto do SSMS utilizando uma VPN?"},"content":{"rendered":"<p>Fala Pessoal,<\/p>\n<p>No meu post anterior criamos uma MI.<\/p>\n<p>Mas e ai Fabr\u00edcio, como eu acesso o MI? Tentei aqui e n\u00e3o funcionou&#8230;<\/p>\n<p>Antes de seguir, sugiro ler os posts anteriores caso ainda na\u00f5 tenha visto:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/03\/17\/azure-sql-db-managed-instance-introducao\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.fabriciolima.net\/blog\/2018\/03\/17\/azure-sql-db-managed-instance-introducao\/<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/16\/managed-instance-criando-minha-primeira-instancia\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.fabriciolima.net\/blog\/2018\/11\/16\/managed-instance-criando-minha-primeira-instancia\/<\/a><\/li>\n<\/ul>\n<p>Ap\u00f3s concluir a cria\u00e7\u00e3o do Managed Instance, clicando nele, podemos ver essa mensagem destacada em verde:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9639 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1.png\" alt=\"\" width=\"948\" height=\"266\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1.png 1589w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-300x84.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-1024x287.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-768x216.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-1536x431.png 1536w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-700x196.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-410x115.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-100x28.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-275x77.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_1-20x6.png 20w\" sizes=\"auto, (max-width: 948px) 100vw, 948px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>O Azure nos fornece duas op\u00e7\u00f5es para acessar o MI via SSMS, uma atrav\u00e9s de uma VM com SSMS e outra atrav\u00e9s de uma VPN com o SSMS na sua m\u00e1quina.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9638 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2.png\" alt=\"\" width=\"454\" height=\"565\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2.png 649w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2-241x300.png 241w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2-410x510.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2-100x124.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2-275x342.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_2-16x20.png 16w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>O Azure fornece scripts em powershell prontos para configurar tudo para voc\u00eas.<\/p>\n<p>Contudo, eu tentei rodar os as duas op\u00e7\u00f5es, coloquei os par\u00e2metros do meu ambiente, mas nenhum dos dois funcionou. Fa\u00e7am um teste e dando certo comentem aqui no post para eu saber.<\/p>\n<p>Nesse post vamos fazer manualmente a configura\u00e7\u00e3o da VPN. Em um pr\u00f3ximo posso falar do acesso via VM (nesse caso voc\u00ea ter\u00e1 um custo para manter essa VM a mais).<\/p>\n<p>O primeiro passo \u00e9 criarmos um Virtual Network Gateway para nossa VPN:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9637 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1.png\" alt=\"\" width=\"604\" height=\"486\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1.png 1006w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-300x241.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-768x618.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-700x563.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-410x330.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-100x80.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-275x221.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_1-20x16.png 20w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>1 &#8211; Clica em Create a Resource.<\/p>\n<p>2 &#8211; Digite Virtual Network Gateway.<\/p>\n<p>3 &#8211; Clique em Create.<\/p>\n<p>Em seguida, abra o recurso criado e configure conforme abaixo:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9636 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2.png\" alt=\"\" width=\"1137\" height=\"564\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2.png 1814w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-300x149.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-1024x509.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-768x381.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-1536x763.png 1536w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-700x348.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-410x204.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-100x50.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-275x137.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_2-20x10.png 20w\" sizes=\"auto, (max-width: 1137px) 100vw, 1137px\" \/><\/p>\n<p>1 &#8211; Escolha um nome para o seu Gateway.<\/p>\n<p>2 &#8211; Utilize a vnet que foi criada quando criamos nossa MI no post anterior.<\/p>\n<p>3 &#8211; D\u00ea um nome para o IP que ser\u00e1 gerado automaticamente.<\/p>\n<p>4 &#8211; Escolha a subscription.<\/p>\n<p>5 &#8211; Utilize a mesma localiza\u00e7\u00e3o que criou o MI.<\/p>\n<p>Clique em CREATE.<\/p>\n<p>Ap\u00f3s concluir o deploy, olhando meu Resource Group onde coloquei tudo da minha inst\u00e2ncia gerenciada, podemos ver que temos 2 novos objetos:<\/p>\n<ul>\n<li>Public Ip Adress<\/li>\n<li>Virtual Network Gateway<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9635 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3.png\" alt=\"\" width=\"938\" height=\"408\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3.png 1676w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-300x130.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-1024x445.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-768x334.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-1536x667.png 1536w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-700x304.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-410x178.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-100x43.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-275x119.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_3-20x9.png 20w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Abra o Virtual Network Gateway que acabamos de criar:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9648 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4.png\" alt=\"\" width=\"921\" height=\"507\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4.png 1421w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-300x165.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-1024x564.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-768x423.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-700x385.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-410x226.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-100x55.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-275x151.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-20x11.png 20w\" sizes=\"auto, (max-width: 921px) 100vw, 921px\" \/><\/p>\n<p>1 &#8211; Clique em Point-to-site configuration<\/p>\n<p>2 &#8211; Adicione um Address pool. \u00c9 um range de ip privado que temos que especificar. Os clientes que se conectam atrav\u00e9s da nossa VPN v\u00e3o receber um IP desse dinamicamente.<\/p>\n<p>3 &#8211; O item 3 \u00e9 um pouco chato de se fazer.<\/p>\n<p>Para gerar e exportar o certificado da nossa VPN (item 3 da figura), vamos seguir o documento abaixo:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/vpn-gateway\/vpn-gateway-certificates-point-to-site#clientcert\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.microsoft.com\/en-us\/azure\/vpn-gateway\/vpn-gateway-certificates-point-to-site#clientcert<\/a><\/li>\n<\/ul>\n<p>Primeiro temos que rodar esse comando powershell para criar nosso certificado root:<\/p>\n<pre class=\"lang:tsql decode:true\">$cert = New-SelfSignedCertificate -Type Custom -KeySpec Signature `\r\n-Subject \"CN=P2SRootCertMIbusinessCritical\" -KeyExportPolicy Exportable `\r\n-HashAlgorithm sha256 -KeyLength 2048 `\r\n-CertStoreLocation \"Cert:\\CurrentUser\\My\" -KeyUsageProperty Sign -KeyUsage CertSign<\/pre>\n<p>Coloquei esse nome no meu:<strong>\u00a0P2SRootCertMIbusinessCritical<\/strong><\/p>\n<p>Logo em seguida, na tela do powershell temos que rodar o comando abaixo para gerar o certificado que j\u00e1 \u00e9 automaticamente instalado em nossa m\u00e1quina.<\/p>\n<p>Todo computador que vai conectar na nossa VNet tem que ter esse certificado instalado.<\/p>\n<pre class=\"lang:tsql decode:true\">New-SelfSignedCertificate -Type Custom -DnsName P2SChildCert -KeySpec Signature `\r\n-Subject \"CN=P2SChildCertmibusinesscritical\" -KeyExportPolicy Exportable `\r\n-HashAlgorithm sha256 -KeyLength 2048 `\r\n-CertStoreLocation \"Cert:\\CurrentUser\\My\" `\r\n-Signer $cert -TextExtension @(\"2.5.29.37={text}1.3.6.1.5.5.7.3.2\")<\/pre>\n<p>Coloquei esse nome no meu:<strong> P2SChildCertmibusinesscritical<\/strong><\/p>\n<p>Segue os dois certificados criados na minha m\u00e1quina (win+<strong>certmgr.msc<\/strong>\u00a0 para visualizar).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9647 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5.png\" alt=\"\" width=\"897\" height=\"217\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5.png 1360w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-300x73.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-1024x248.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-768x186.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-700x169.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-410x99.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-100x24.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-275x67.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_5-20x5.png 20w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/p>\n<p>O pr\u00f3ximo passo \u00e9 exportar o certificado root para gerar o c\u00f3digo e colocar no Azure (item 3).<\/p>\n<p>Ainda na tela do certificado, clique no certificado Root (<strong>P2SRootCertMIbusinessCritical<\/strong>) com o bot\u00e3o direito<strong>-&gt;<\/strong>All Taks-&gt;Export<\/p>\n<p>No <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/vpn-gateway\/vpn-gateway-certificates-point-to-site#clientcert\" target=\"_blank\" rel=\"noopener\">link<\/a> que coloquei tem os prints em detalhes, aqui vou s\u00f3 descrever para encurtar o post.<\/p>\n<p>Abrindo a tela, clique em next-&gt;Mantenha a op\u00e7\u00e3o <strong>&#8220;No&#8221;<\/strong>-&gt;Nessa pr\u00f3xima tela mude para <strong>&#8220;Base-64 encoded X.509(.CER)&#8221;<\/strong>-&gt;Escolha um caminho e salve o certificado-&gt;Finish<\/p>\n<p>Abra o certificado que acabou de salvar em um bloco de notas e copie o texto gerado conforme o print abaixo (meu arquivo se chama <strong>rootBC<\/strong>):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9646 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6.png\" alt=\"\" width=\"513\" height=\"379\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6.png 756w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6-300x222.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6-700x518.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6-410x303.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6-100x74.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6-275x203.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_6-20x15.png 20w\" sizes=\"auto, (max-width: 513px) 100vw, 513px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Agora basta copiar esse c\u00f3digo e colocar na configura\u00e7\u00e3o do Gateway que estamos criando para nossa VPN (item 3):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9648 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4.png\" alt=\"\" width=\"693\" height=\"381\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4.png 1421w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-300x165.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-1024x564.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-768x423.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-700x385.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-410x226.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-100x55.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-275x151.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_4-20x11.png 20w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><\/p>\n<p>Coloque o nome do arquivo do certificado e o c\u00f3digo que copiamos desse arquivo.<\/p>\n<p>4 &#8211; O \u00faltimo passo \u00e9 fazer o Download do arquivo de configura\u00e7\u00e3o da nossa VPN.<\/p>\n<p>Baixe ele, quando abrir ver\u00e1 3 pastas, execute de acordo com a arquitetura da sua m\u00e1quina (no meu caso rodei o da pasta <strong>WindowsAmd64<\/strong>).<\/p>\n<p>Abra as vpn do windows, vai ver a VPN j\u00e1 criada <strong>&#8220;vnet-mibusinesscritical&#8221;<\/strong>. Se tudo deu certo, vai conseguir conectar:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9651 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7.png\" alt=\"\" width=\"421\" height=\"291\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7.png 667w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7-300x207.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7-410x283.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7-100x69.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7-275x190.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_7-20x14.png 20w\" sizes=\"auto, (max-width: 421px) 100vw, 421px\" \/><\/p>\n<p>Ap\u00f3s logado na VPN, para conectar via SSMS \u00e9 parecido com o Azure SQL Database.<\/p>\n<p>Pegue o endere\u00e7o da inst\u00e2ncia no portal e autentique com o usu\u00e1rio e senha que criou:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9650 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8.png\" alt=\"\" width=\"1150\" height=\"300\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8.png 1772w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-300x78.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-1024x267.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-768x200.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-1536x400.png 1536w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-700x183.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-410x107.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-100x26.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-275x72.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_8-20x5.png 20w\" sizes=\"auto, (max-width: 1150px) 100vw, 1150px\" \/><\/p>\n<p>Ufa! Depois de todo esse trabalho, finalmente consegui me conectar:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9649 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9.png\" alt=\"\" width=\"917\" height=\"349\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9.png 1405w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-300x114.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-1024x390.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-768x292.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-700x267.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-410x156.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-100x38.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-275x105.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_conexao_VPN_9-20x8.png 20w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Agrade\u00e7o novamente ao <strong>Dimitri<\/strong> que citei no post anterior. Estava batendo cabe\u00e7a para fazer isso funcionar na minha m\u00e1quina.<\/p>\n<p>Quem tiver cr\u00e9ditos no Azure para testar, fa\u00e7a e me d\u00ea o feedback se deu tudo certo.<\/p>\n<p>At\u00e9 o pr\u00f3ximo post.<\/p>\n<p>Abra\u00e7os,<\/p>\n<p>Fabr\u00edcio Lima<\/p>\n<p>Microsoft Data Platform MVP<\/p>\n<p>Consultor e Instrutor SQL Server<\/p>\n<p>Trabalha com SQL Server desde 2006<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fala Pessoal, No meu post anterior criamos uma MI. Mas e ai Fabr\u00edcio, como eu acesso o MI? Tentei aqui e n\u00e3o funcionou&#8230; Antes de seguir, sugiro ler os posts anteriores caso ainda na\u00f5 tenha visto: https:\/\/www.fabriciolima.net\/blog\/2018\/03\/17\/azure-sql-db-managed-instance-introducao\/ https:\/\/www.fabriciolima.net\/blog\/2018\/11\/16\/managed-instance-criando-minha-primeira-instancia\/ Ap\u00f3s concluir a cria\u00e7\u00e3o do Managed Instance, clicando nele, podemos ver essa mensagem destacada em verde: &nbsp; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[1616,1617,1512,33,280],"tags":[],"class_list":["post-9644","post","type-post","status-publish","format-standard","hentry","category-azure-sql-database","category-managed-instance","category-sql-azure","category-sql-server","category-virtual-pass-br"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/9644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/comments?post=9644"}],"version-history":[{"count":6,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/9644\/revisions"}],"predecessor-version":[{"id":9706,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/9644\/revisions\/9706"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=9644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=9644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=9644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}