{"id":1209,"date":"2018-01-16T14:39:28","date_gmt":"2018-01-16T14:39:28","guid":{"rendered":"https:\/\/www.tiagoneves.net\/blog\/?p=1209"},"modified":"2018-01-23T00:49:56","modified_gmt":"2018-01-23T00:49:56","slug":"instalando-o-sql-server-2017","status":"publish","type":"post","link":"https:\/\/www.tiagoneves.net\/blog\/instalando-o-sql-server-2017\/","title":{"rendered":"Instalando o SQL Server 2017"},"content":{"rendered":"<p style=\"text-align: justify;\">Ol\u00e1 pessoal tudo certo?<\/p>\n<p style=\"text-align: justify;\">Espero que todos tenham come\u00e7ado bem o ano de 2018.<\/p>\n<p style=\"text-align: justify;\">Bom como \u00e9 de conhecimento da grande maioria em Outubro de 2017, a Microsoft lan\u00e7ou o SQL Server 2017, esse que talvez seja o maior lan\u00e7amento dos \u00faltimos tempos, pois agora o SQL Server finalmente vai rodar no Linux, agora n\u00e3o vamos mais ouvir dos nossos amigos DBA&#8217;s Oracle, que o SQL Server n\u00e3o \u00e9 multiplataforma.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m de rodar no Linux e em Docker, o produto tem outras novidades como o suporte a Python, podemos pausar o rebuild de \u00edndices e retomar em outro hor\u00e1rio, inst\u00e2ncias que tem mais um banco de dados e\u00a0 executam transa\u00e7\u00f5es com cross-database, passam a ter suporte ao \u00a0<strong>Always On Availability Group<\/strong>, entre outras novidades.<\/p>\n<p style=\"text-align: justify;\">Para saber todas as novidades basta acessar o link. (<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2017\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2017<\/a>).<\/p>\n<p style=\"text-align: justify;\">Este post tem a inten\u00e7\u00e3o de demonstrar como fazer a instala\u00e7\u00e3o o SQL Server tanto no Linux quanto no Windows Server.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #3366ff;\"><strong>Instalando o SQL Server no Linux<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Neste post vamos apenas instalar o SQL Server no Linux, n\u00e3o vamos cobrir como fazer a instala\u00e7\u00e3o do Linux. O SQL Server est\u00e1 dispon\u00edvel para as distribui\u00e7\u00f5es Ubuntu, Suse e Redhat, embora no primeiro post que fiz sobre SQL Server Vnext fiz a instala\u00e7\u00e3o no CentOS, se quiser conferir basta clicar <a href=\"https:\/\/www.tiagoneves.net\/blog\/sql-server-on-linux-parte-2\/\" target=\"_blank\" rel=\"noopener\">aqui<\/a>.<\/p>\n<p style=\"text-align: justify;\">Neste post vamos utilizar a distribui\u00e7\u00e3o <a href=\"https:\/\/www.ubuntu.com\/desktop\/1710\" target=\"_blank\" rel=\"noopener\">Ubuntu<\/a>.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Pr\u00e9-Requisitos:<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para fazer a instala\u00e7\u00e3o do SQL Server no Ubuntu, voc\u00ea tem que ter instalado no m\u00ednimo a build 16.04 com 4 GB de mem\u00f3ria, embora a documenta\u00e7\u00e3o oficial n\u00e3o diga o quanto de espa\u00e7o em disco devemos ter, eu indico voc\u00ea ter ter pelos menos 10 GB livres.<\/p>\n<p style=\"text-align: justify;\">Ap\u00f3s fazer a instala\u00e7\u00e3o do Ubuntu, voc\u00ea deve executar um update para atualizar o SO e atualizar os pacotes, para fazer isso voc\u00ea deve executar o seguinte comando:<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">Sudo apt-get update<\/pre>\n<p style=\"text-align: justify;\">Para executar este comando voc\u00ea ter\u00e1 que elevar o seu usu\u00e1rio para root, voc\u00ea precisa digitar a senha do root que voc\u00ea definiu na instala\u00e7\u00e3o.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_UpdateSO.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1210 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_UpdateSO.png?resize=678%2C223&#038;ssl=1\" alt=\"\" width=\"678\" height=\"223\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_UpdateSO.png?w=1153&amp;ssl=1 1153w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_UpdateSO.png?resize=300%2C99&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_UpdateSO.png?resize=768%2C252&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_UpdateSO.png?resize=1024%2C337&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Agora vamos fazer a instala\u00e7\u00e3o dos pacotes que foram encontrados, para realizar a instala\u00e7\u00e3o voc\u00ea deve executar o seguinte comando:<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">Sudo apt-get upgrade<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1211 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO.png?resize=678%2C510&#038;ssl=1\" alt=\"\" width=\"678\" height=\"510\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO.png?w=1152&amp;ssl=1 1152w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO.png?resize=768%2C577&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO.png?resize=1024%2C770&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO_Completed.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1212 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO_Completed.png?resize=678%2C511&#038;ssl=1\" alt=\"\" width=\"678\" height=\"511\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO_Completed.png?w=1150&amp;ssl=1 1150w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO_Completed.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO_Completed.png?resize=768%2C578&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_UpdateSO_Completed.png?resize=1024%2C771&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Ap\u00f3s a instala\u00e7\u00e3o dos novos pacotes \u00e9 recomendado dar um boot no servidor.<\/p>\n<p>Agora podemos dar iniciar a instala\u00e7\u00e3o do SQL Server 2017 no Ubuntu.<\/p>\n<p>O primeiro passo \u00e9 importar a chave <a href=\"https:\/\/access.redhat.com\/documentation\/pt-br\/red_hat_enterprise_linux\/6\/html\/security_guide\/sect-security_guide-encryption-using_gpg-creating_gpg_keys_in_kde\" target=\"_blank\" rel=\"noopener\">GPG<\/a> para o reposit\u00f3rio, para fazer isso basta executar o comando abaixo:<\/p>\n<pre class=\"theme:terminal lang:vim decode:true\">curl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add -<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_ImportKey_Microsoft.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1215 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_ImportKey_Microsoft.png?resize=678%2C99&#038;ssl=1\" alt=\"\" width=\"678\" height=\"99\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_ImportKey_Microsoft.png?w=1156&amp;ssl=1 1156w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_ImportKey_Microsoft.png?resize=300%2C44&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_ImportKey_Microsoft.png?resize=768%2C112&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_ImportKey_Microsoft.png?resize=1024%2C149&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Agora \u00e9 necess\u00e1rio registrar o reposit\u00f3rio da Microsoft SQL Server no Ubuntu:<\/p>\n<pre class=\"theme:terminal lang:vim decode:true\">sudo add-apt-repository \"$(curl https:\/\/packages.microsoft.com\/config\/ubuntu\/16.04\/mssql-server-2017.list)\"<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Resgister_Microsoft_Repository.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1216 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Resgister_Microsoft_Repository.png?resize=678%2C97&#038;ssl=1\" alt=\"\" width=\"678\" height=\"97\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Resgister_Microsoft_Repository.png?w=1152&amp;ssl=1 1152w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Resgister_Microsoft_Repository.png?resize=300%2C43&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Resgister_Microsoft_Repository.png?resize=768%2C110&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Resgister_Microsoft_Repository.png?resize=1024%2C147&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Feito isso vamos fazer o download, das atualiza\u00e7\u00f5es da Microsoft utilizando o comando:<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">sudo apt-get update<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_Microsoft.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1217 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_Microsoft.png?resize=678%2C155&#038;ssl=1\" alt=\"\" width=\"678\" height=\"155\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_Microsoft.png?w=1156&amp;ssl=1 1156w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_Microsoft.png?resize=300%2C69&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_Microsoft.png?resize=768%2C176&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_Microsoft.png?resize=1024%2C235&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O SQL Server est\u00e1 pronto para ser instalado, basta executar o seguinte comando:<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">sudo apt-get install -y mssql-server<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1218 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer.png?resize=678%2C510&#038;ssl=1\" alt=\"\" width=\"678\" height=\"510\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer.png?w=1152&amp;ssl=1 1152w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer.png?resize=768%2C577&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer.png?resize=1024%2C770&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Para concluir a instala\u00e7\u00e3o e iniciar as configura\u00e7\u00f5es da inst\u00e2ncia devemos executar o comando:<\/p>\n<pre class=\"theme:terminal lang:sh decode:true\">sudo \/opt\/mssql\/bin\/mssql-conf setup<\/pre>\n<p>Agora devemos escolher qual a edi\u00e7\u00e3o do SQL Server vamos utilizar, neste caso vamos utilizar a edi\u00e7\u00e3o &#8220;<em>developer<\/em>&#8220;, que n\u00e3o precisa ser licenciada e tem todas a features liberadas. Lembrando que n\u00e3o podemos utilizar a edi\u00e7\u00e3o developer em produ\u00e7\u00e3o.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1219 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration.png?resize=678%2C221&#038;ssl=1\" alt=\"\" width=\"678\" height=\"221\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration.png?w=1149&amp;ssl=1 1149w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration.png?resize=300%2C98&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration.png?resize=768%2C251&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration.png?resize=1024%2C334&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Agora devemos escolher o idioma que vamos utilizar.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Language.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1220 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Language.png?resize=678%2C180&#038;ssl=1\" alt=\"\" width=\"678\" height=\"180\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Language.png?w=1153&amp;ssl=1 1153w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Language.png?resize=300%2C80&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Language.png?resize=768%2C204&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Language.png?resize=1024%2C272&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O pr\u00f3ximo passo \u00e9 informar a senha do <em>SA<\/em>.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Set_Password.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1221 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Set_Password.png?resize=678%2C98&#038;ssl=1\" alt=\"\" width=\"678\" height=\"98\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Set_Password.png?w=1150&amp;ssl=1 1150w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Set_Password.png?resize=300%2C44&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Set_Password.png?resize=768%2C112&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Configuration_Set_Password.png?resize=1024%2C149&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Pronto a instala\u00e7\u00e3o do SQL Server est\u00e1 conclu\u00edda, por\u00e9m no Linux voc\u00ea necessita realizar a instala\u00e7\u00e3o como se fosse m\u00f3dulos, diferentemente do Windows que quando fazemos a instala\u00e7\u00e3o podemos instalar tudo de vez.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1222\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?resize=678%2C126&#038;ssl=1\" alt=\"\" width=\"678\" height=\"126\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?w=1858&amp;ssl=1 1858w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?resize=300%2C56&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?resize=768%2C143&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?resize=1024%2C190&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<h3><span style=\"color: #3366ff;\"><strong>Instalando SQL Server Agent<\/strong><\/span><\/h3>\n<h3>Pr\u00e9-requisito<\/h3>\n<p>O pr\u00e9-requisto para fazer a instala\u00e7\u00e3o do SQL Server Agent \u00e9 ter o SQL Server instalado.<\/p>\n<p>Para fazer a instala\u00e7\u00e3o do SQL Server devemos seguir alguns passos que j\u00e1 realizamos que \u00e9 atualizar os pacotes do SQL Server.<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">sudo apt-get update<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_SQLSERVER.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1223 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_SQLSERVER.png?resize=678%2C179&#038;ssl=1\" alt=\"\" width=\"678\" height=\"179\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_SQLSERVER.png?w=1156&amp;ssl=1 1156w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_SQLSERVER.png?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_SQLSERVER.png?resize=768%2C203&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Update_SQLSERVER.png?resize=1024%2C271&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Feito isso j\u00e1 podemos fazer a instala\u00e7\u00e3o do SQL Server Agent.<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">sudo apt-get install mssql-server-agent\r\n<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1224 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent.png?resize=678%2C242&#038;ssl=1\" alt=\"\" width=\"678\" height=\"242\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent.png?w=1150&amp;ssl=1 1150w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent.png?resize=300%2C107&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent.png?resize=768%2C274&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent.png?resize=1024%2C365&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Ap\u00f3s o termino da instala\u00e7\u00e3o precisamos reiniciar o servi\u00e7o do SQL Server.<\/p>\n<pre class=\"theme:terminal lang:sh decode:true \">sudo systemctl restart mssql-server<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent_Restart.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1225\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent_Restart.png?resize=678%2C45&#038;ssl=1\" alt=\"\" width=\"678\" height=\"45\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent_Restart.png?w=1150&amp;ssl=1 1150w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent_Restart.png?resize=300%2C20&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent_Restart.png?resize=768%2C51&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_Install_SQLServer_Agent_Restart.png?resize=1024%2C68&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1226\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?resize=678%2C156&#038;ssl=1\" alt=\"\" width=\"678\" height=\"156\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?w=1858&amp;ssl=1 1858w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?resize=300%2C69&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?resize=768%2C177&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?resize=1024%2C236&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLServer2017_On_Linux_SSMS_Agent.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Agora podemos criar job normalmente, inclusive configurar o databasemail.<\/p>\n<p>Para conferir os servi\u00e7os e feature compativeis com o Linux basta acessar a documenta\u00e7\u00e3o da <a href=\"https:\/\/docs.microsoft.com\/pt-br\/sql\/linux\/sql-server-linux-editions-and-components-2017\" target=\"_blank\" rel=\"noopener\">Microsoft<\/a>.<\/p>\n<p>(<a href=\"https:\/\/docs.microsoft.com\/pt-br\/sql\/linux\/sql-server-linux-editions-and-components-2017\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.microsoft.com\/pt-br\/sql\/linux\/sql-server-linux-editions-and-components-2017<\/a>)<\/p>\n<h3><span style=\"color: #0000ff;\"><strong>\u00a0Limita\u00e7\u00f5es do SQL Server 2017 on Linux<\/strong><\/span><\/h3>\n<p>O SQL Server 2017 executando no Linux ainda tem algumas limita\u00e7\u00f5es, como por exemplo o suporte a CLR (gra\u00e7as a Deus) e Mirror.<\/p>\n<p>Confira na lista abaixo as limita\u00e7\u00f5es do SQL Server on Linux.<\/p>\n<table>\n<tbody>\n<tr>\n<th><span data-ttu-id=\"727eb-254\">\u00c1rea<\/span><\/th>\n<th><span data-ttu-id=\"727eb-255\">N\u00e3o h\u00e1 suporte para recurso ou servi\u00e7o<\/span><\/th>\n<\/tr>\n<tr>\n<td><strong>Engine de Dados<\/strong><\/td>\n<td><span data-ttu-id=\"727eb-257\">Replica\u00e7\u00e3o transacional<\/span><\/td>\n<\/tr>\n<tr>\n<td class=\"\"><\/td>\n<td><span data-ttu-id=\"727eb-258\">Replica\u00e7\u00e3o de mesclagem<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td class=\"\"><span data-ttu-id=\"727eb-259\">Stretch DB<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-260\">Polybase<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-261\">Consulta distribu\u00edda com conex\u00f5es 3\u00aa parte<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-262\">Sistema os procedimentos armazenados estendidos (XP_CMDSHELL, etc.)<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-263\">Tabela de arquivos, FILESTREAM<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-264\">O conjunto de assemblies do CLR com o EXTERNAL_ACCESS ou UNSAFE permiss\u00e3o<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-265\">Buffer Pool Extension<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-ttu-id=\"727eb-266\"><strong>SQL Server Agent<\/strong><\/span><\/td>\n<td><span data-ttu-id=\"727eb-267\">Subsistemas: CmdExec, PowerShell, leitor de fila, SSIS, SSAS, SSRS<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-268\">Alertas<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-269\">Agente de Leitor de Log<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-270\">Change Data Capture<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-271\">Backup Gerenciado<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-ttu-id=\"727eb-272\"><strong>Alta disponibilidade<\/strong><\/span><\/td>\n<td><span data-ttu-id=\"727eb-273\">Espelhamento de banco de dados<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-ttu-id=\"727eb-274\"><strong>Seguran\u00e7a<\/strong><\/span><\/td>\n<td><span data-ttu-id=\"727eb-275\">Gerenciamento Extens\u00edvel de Chaves<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-276\">Autentica\u00e7\u00e3o do AD para servidores vinculados<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-277\">Autentica\u00e7\u00e3o do AD para grupos de disponibilidade (grupos de disponibilidade)<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-278\">ferramentas de terceiros AD 3\u00ba (Centrify, Vintela, Powerbroker)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-ttu-id=\"727eb-279\"><strong>Servi\u00e7os<\/strong><\/span><\/td>\n<td><span data-ttu-id=\"727eb-280\">SQL Server Browser<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-281\">SQL Server R services<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-282\">StreamInsight<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-283\">Analysis Services<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><span data-ttu-id=\"727eb-284\">Reporting Services<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td class=\"\"><span data-ttu-id=\"727eb-285\">Data Quality Services<\/span><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td class=\"\"><span data-ttu-id=\"727eb-286\">Master Data Services<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>As limita\u00e7\u00f5es podem deixar de existir conforme o produto for aprimorado, voc\u00ea pode conferir as limita\u00e7\u00f5es na documenta\u00e7\u00e3o do produto (<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-release-notes\" target=\"_blank\" rel=\"noopener\">clique aqui<\/a>).<\/p>\n<h3><span style=\"color: #0000ff;\"><strong>Instalando o SQL Server 2017 no Windows\u00a0 Server<\/strong><\/span><\/h3>\n<p>Agora vamos realizar a instala\u00e7\u00e3o do SQL Server no Windows Server, O SO da minha VM \u00e9 o Windows Server 2016, mas o SQL Server 2017 \u00e9 compat\u00edvel com o Windows Server 2012.<\/p>\n<p>Para fazer a instala\u00e7\u00e3o recomendo que voc\u00ea tenha uma conta de servi\u00e7o para configurar o SQL Server, est\u00e1 conta deve ter o menor acesso poss\u00edvel, eu particularmente gosto de criar uma conta para cada servi\u00e7o do SQL Server (Agent, Integration, Reporting&#8230;).<\/p>\n<h4><span style=\"color: #000000;\"><strong>Pr\u00e9-Requisitos:<\/strong><\/span><\/h4>\n<p>Para fazer a instala\u00e7\u00e3o do SQL Server 2017, \u00e9 recomendado ter pelo menos 10 GB de espa\u00e7o em disco, 4 GB de mem\u00f3ria e processadores x64, al\u00e9m do Windows Server a partir do Windows Server 2012. Voc\u00ea tamb\u00e9m pode fazer a instala\u00e7\u00e3o do SQL Server 2017 em um desktop a partir do Windows 8.<\/p>\n<p>Para fazer o post vamos utilizar a m\u00eddia do <a href=\"https:\/\/www.microsoft.com\/pt-br\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noopener\">SQL Server 2017 Developer<\/a> que pode ser baixado gratuitamente, lembrando que n\u00e3o pode em hip\u00f3tese nenhuma ser utilizado em produ\u00e7\u00e3o.<\/p>\n<p>Ao iniciar a instala\u00e7\u00e3o devemos clicar em &#8220;<em>Installation<\/em>&#8221;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1236 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center.png?resize=678%2C511&#038;ssl=1\" alt=\"\" width=\"678\" height=\"511\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center.png?w=784&amp;ssl=1 784w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center.png?resize=768%2C579&amp;ssl=1 768w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Agora devemos escolher o tipo de instala\u00e7\u00e3o a principio vamos utilizar a instala\u00e7\u00e3o stand-alone.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_SelectInstallation.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1237 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_SelectInstallation.png?resize=678%2C512&#038;ssl=1\" alt=\"\" width=\"678\" height=\"512\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_SelectInstallation.png?w=783&amp;ssl=1 783w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_SelectInstallation.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_SelectInstallation.png?resize=768%2C580&amp;ssl=1 768w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O pr\u00f3ximo passo \u00e9 inserir a licen\u00e7a, como estamos utilizando um m\u00eddia Developer, n\u00e3o precisamos inserir a chave.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1238 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense.png?resize=678%2C510&#038;ssl=1\" alt=\"\" width=\"678\" height=\"510\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense.png?w=806&amp;ssl=1 806w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense.png?resize=768%2C577&amp;ssl=1 768w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Voc\u00ea deve aceitar os termos da licen\u00e7a.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense_2.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1239 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense_2.png?resize=678%2C510&#038;ssl=1\" alt=\"\" width=\"678\" height=\"510\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense_2.png?w=807&amp;ssl=1 807w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense_2.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_AcceptLicense_2.png?resize=768%2C578&amp;ssl=1 768w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Agora o instalador do SQL Server ir\u00e1 fazer uma valida\u00e7\u00e3o no seu servidor para verificar se ele est\u00e1 compliance para realizar a instala\u00e7\u00e3o. Estando tudo Ok, ele vai perguntar se voc\u00ea deseja buscar atualiza\u00e7\u00f5es online, normalmente eu n\u00e3o utilizo essa op\u00e7\u00e3o, pois gosto de realizar o download e aplicar as atualiza\u00e7\u00f5es ap\u00f3s a instala\u00e7\u00e3o.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_Buscar_Updates.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1240 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_Buscar_Updates.png?resize=678%2C511&#038;ssl=1\" alt=\"\" width=\"678\" height=\"511\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_Buscar_Updates.png?w=806&amp;ssl=1 806w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_Buscar_Updates.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Center_Buscar_Updates.png?resize=768%2C578&amp;ssl=1 768w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O pr\u00f3ximo passo \u00e9 escolher quais features vamos instalar, diferentemente do Linux o instalador do SQL Server 2017, traz todas a features no instalador, exceto Reporting Server que voc\u00ea dever\u00e1 realizar o <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=55252\" target=\"_blank\" rel=\"noopener\">download<\/a> do instalador separado. Lembrando que desde o SQL Server 2016 o Management Studio n\u00e3o faz mais parte do pacote e deve ser instalado separadamente, se quiser informa\u00e7\u00f5es sobre como instalar o SSMS, basta clicar verificar este post (<em><a href=\"https:\/\/www.tiagoneves.net\/blog\/instalando-o-sql-server-2016-e-o-management-studio\/\" target=\"_blank\" rel=\"noopener\">Instalando o SQL Server 2016 e o Management Studio<\/a>).<\/em><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Select_Features.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1242 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Select_Features.png?resize=678%2C447&#038;ssl=1\" alt=\"\" width=\"678\" height=\"447\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Select_Features.png?w=1332&amp;ssl=1 1332w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Select_Features.png?resize=300%2C198&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Select_Features.png?resize=768%2C507&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Select_Features.png?resize=1024%2C676&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Selecionadas as features que ser\u00e3o instaladas, o pr\u00f3ximo passo \u00e9 realizar a configura\u00e7\u00e3o de como ser\u00e1 instalado o seu SQL Server.<\/p>\n<p>O primeiro passo \u00e9 definir o nome da inst\u00e2ncia ou se vamos utilizar a inst\u00e2ncia default &#8220;<em>MSSQLSERVER<\/em>&#8220;.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Name.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1243 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Name.png?resize=678%2C470&#038;ssl=1\" alt=\"\" width=\"678\" height=\"470\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Name.png?w=1039&amp;ssl=1 1039w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Name.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Name.png?resize=768%2C533&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Name.png?resize=1024%2C711&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O segundo passo \u00e9 fazer a configura\u00e7\u00e3o da conta de servi\u00e7o e qual <em>Collation<\/em> vamos utilizar, lembrando que a <em>Collation<\/em> \u00e9 suma import\u00e2ncia, uma vez instalada para alterar a somente com &#8220;gambiarras&#8221;.<\/p>\n<p>A partir do SQL Server 2016, \u00e9 poss\u00edvel configurar o acesso na Policy \u201c<em><a class=\"wpel-icon-left\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms175935.aspx\" target=\"_blank\" rel=\"nofollow external noopener noreferrer\" data-wpel-link=\"external\">Perform volume maintenance tasks<\/a><\/em>\u201c, j\u00e1 na instala\u00e7\u00e3o em outras vers\u00f5es do SQL Server voc\u00ea tinha que dar a permiss\u00e3o manualmente.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_UserAccountAndCollation.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1246 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_UserAccountAndCollation.png?resize=678%2C472&#038;ssl=1\" alt=\"\" width=\"678\" height=\"472\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_UserAccountAndCollation.png?w=1036&amp;ssl=1 1036w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_UserAccountAndCollation.png?resize=300%2C209&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_UserAccountAndCollation.png?resize=768%2C534&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_UserAccountAndCollation.png?resize=1024%2C713&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Collation.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1247 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Collation.png?resize=678%2C470&#038;ssl=1\" alt=\"\" width=\"678\" height=\"470\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Collation.png?w=1039&amp;ssl=1 1039w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Collation.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Collation.png?resize=768%2C533&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Collation.png?resize=1024%2C711&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>\u00c9 uma boa pratica configurar o servi\u00e7o do SQL Server Agent para iniciar autom\u00e1tico.<\/p>\n<p>O pr\u00f3ximo passo \u00e9 fazer a configura\u00e7\u00e3o de seguran\u00e7a, onde vamos definir as contas que ser\u00e3o <em>Sysadmin<\/em> e a senha do <em>SA<\/em>.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_SA.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1248 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_SA.png?resize=678%2C470&#038;ssl=1\" alt=\"\" width=\"678\" height=\"470\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_SA.png?w=1037&amp;ssl=1 1037w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_SA.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_SA.png?resize=768%2C532&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_SA.png?resize=1024%2C710&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O quarto passo \u00e9 realizar a configura\u00e7\u00e3o dos diret\u00f3rios das databases (<em>diret\u00f3rio onde ser\u00e1 armazenado os arquivos de dados e log<\/em>).<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Directory.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1249 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Directory.png?resize=678%2C472&#038;ssl=1\" alt=\"\" width=\"678\" height=\"472\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Directory.png?w=1036&amp;ssl=1 1036w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Directory.png?resize=300%2C209&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Directory.png?resize=768%2C534&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Directory.png?resize=1024%2C713&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>O quinto passo \u00e9 fazer a configura\u00e7\u00e3o do Tempdb, desde o SQL Server 2016, podemos definir a quantidade de arquivos de dados que vamos criar na instala\u00e7\u00e3o, para entender mais sobre conten\u00e7\u00e3o de Tempdb, o post &#8220;<a href=\"https:\/\/www.tiagoneves.net\/blog\/contencao-de-tempdb-como-resolver\/\" target=\"_blank\" rel=\"noopener\"><em>Conten\u00e7\u00e3o de Tempdb, como resolver?<\/em><\/a>&#8221; explica o que causa e como resolver.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Tempdb.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1250 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Tempdb.png?resize=678%2C471&#038;ssl=1\" alt=\"\" width=\"678\" height=\"471\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Tempdb.png?w=1039&amp;ssl=1 1039w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Tempdb.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Tempdb.png?resize=768%2C534&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Configure_Instance_Tempdb.png?resize=1024%2C712&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Agora vamos conferir o sum\u00e1rio da instala\u00e7\u00e3o e pronto, s\u00f3 mandar instalar.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Sumary.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1251 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Sumary.png?resize=678%2C472&#038;ssl=1\" alt=\"\" width=\"678\" height=\"472\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Sumary.png?w=1039&amp;ssl=1 1039w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Sumary.png?resize=300%2C209&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Sumary.png?resize=768%2C534&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Sumary.png?resize=1024%2C713&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<p>Como podemos verificar a instala\u00e7\u00e3o foi realizada com sucesso.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Concluida_Sucesso.png?ssl=1\" rel=\"lightbox[1209]\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1254 aligncenter\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Concluida_Sucesso.png?resize=678%2C470&#038;ssl=1\" alt=\"\" width=\"678\" height=\"470\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Concluida_Sucesso.png?w=1039&amp;ssl=1 1039w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Concluida_Sucesso.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Concluida_Sucesso.png?resize=768%2C532&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2018\/01\/Install_SQLSERVER2017_WindowsServer_Installation_Concluida_Sucesso.png?resize=1024%2C710&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\"><strong>Referencias:<\/strong><\/span><\/h3>\n<p><a href=\"https:\/\/docs.microsoft.com\/pt-br\/sql\/sql-server\/install\/hardware-and-software-requirements-for-installing-sql-server\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.microsoft.com\/pt-br\/sql\/sql-server\/install\/hardware-and-software-requirements-for-installing-sql-server<\/a><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/installation-for-sql-server\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/installation-for-sql-server<\/a><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/editions-and-components-of-sql-server-2017\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/editions-and-components-of-sql-server-2017<\/a><\/p>\n<p>Bom pessoal, por hoje \u00e9 isso. Espero que todos tenham um excelente ano e espero contribuir muito mais este ano.<\/p>\n<p>Um grande abra\u00e7o.<\/p>\n<p>Tiago Neves<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ol\u00e1 pessoal tudo certo? Espero que todos tenham come\u00e7ado bem o ano de 2018. Bom como \u00e9 de conhecimento da grande maioria em Outubro de 2017, a Microsoft lan\u00e7ou o SQL Server 2017, esse que talvez seja o maior lan\u00e7amento dos \u00faltimos tempos, pois agora o SQL Server finalmente vai rodar no Linux, agora n\u00e3o [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_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":"","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},"_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":[44,220,221,5],"tags":[207,223,203,175,35,222,177],"class_list":["post-1209","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-sql-server-2017","category-sql-server-on-linux","category-virtual-pass-br","tag-dba-es","tag-dba-remoto","tag-dba-vitoria","tag-linux","tag-sql-server","tag-sql-server-2017","tag-sql-server-on-linux"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6eIyh-jv","jetpack-related-posts":[{"id":2414,"url":"https:\/\/www.tiagoneves.net\/blog\/sql-server-2016-esta-chegando-ao-fim-do-suporte-o-que-isso-significa-na-pratica\/","url_meta":{"origin":1209,"position":0},"title":"SQL Server 2016 est\u00e1 chegando ao fim do suporte: o que isso significa na pr\u00e1tica?","author":"tiagoneves","date":"27 de abril de 2026","format":false,"excerpt":"O SQL Server 2016 ter\u00e1 seu suporte estendido encerrado em 14 de julho de 2026, o que resultar\u00e1 na falta de atualiza\u00e7\u00f5es de seguran\u00e7a e suporte. Continuar usando essa vers\u00e3o traz riscos como vulnerabilidades e n\u00e3o conformidade regulat\u00f3ria. Planejar a migra\u00e7\u00e3o para vers\u00f5es mais recentes ou cloud deve ser prioridade\u2026","rel":"","context":"Em &quot;Seguran\u00e7a&quot;","block_context":{"text":"Seguran\u00e7a","link":"https:\/\/www.tiagoneves.net\/blog\/category\/seguranca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/1209","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=1209"}],"version-history":[{"count":21,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/1209\/revisions"}],"predecessor-version":[{"id":1272,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/1209\/revisions\/1272"}],"wp:attachment":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media?parent=1209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/categories?post=1209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/tags?post=1209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}