{"id":62,"date":"2015-05-06T03:34:30","date_gmt":"2015-05-06T03:34:30","guid":{"rendered":"http:\/\/tiagoneves.net\/blog\/?p=62"},"modified":"2015-05-06T03:35:53","modified_gmt":"2015-05-06T03:35:53","slug":"instalando-o-microsoft-sqlserver-2014","status":"publish","type":"post","link":"https:\/\/www.tiagoneves.net\/blog\/instalando-o-microsoft-sqlserver-2014\/","title":{"rendered":"Instalando o Microsoft SQLServer 2014"},"content":{"rendered":"<p>Ol\u00e1 pessoal tudo certo?<\/p>\n<p>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.<\/p>\n<p>Antes de iniciar a instala\u00e7\u00e3o recomendo dar uma lida na documenta\u00e7\u00e3o da Microsoft sobre os requisitos de hardware e software para cada edi\u00e7\u00e3o.<\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb500442.aspx?f=255&amp;MSPPError=-2147217396\" target=\"_blank\" rel=\"noopener\">https:\/\/msdn.microsoft.com\/en-us\/library\/bb500442.aspx?f=255&amp;MSPPError=-2147217396<\/a><\/p>\n<p>Este tutorial parte do princ\u00edpio que se trata de uma instala\u00e7\u00e3o nova.<\/p>\n<p>Ent\u00e3o vamos l\u00e1:<\/p>\n<ul>\n<li>Abra a m\u00eddia contendo contendo o instalador do SQLServer 2014.<\/li>\n<li>Na raiz do diretorio e execute o \u201csetup.exe\u201d<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-65\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg?resize=623%2C380\" alt=\"1\" width=\"623\" height=\"380\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg?w=567&amp;ssl=1 567w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/1.jpg?resize=300%2C183&amp;ssl=1 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/a><\/li>\n<li>Ao executar o setup.exe ser\u00e1 aberto a tela abaixo e voc\u00ea de clicar na guia Installation.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/2.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-66\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/2.jpg?resize=623%2C404\" alt=\"2\" width=\"623\" height=\"404\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/2.jpg?w=675&amp;ssl=1 675w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/2.jpg?resize=300%2C195&amp;ssl=1 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/a><\/li>\n<li>Depois voc\u00ea dever\u00e1 clicar em \u201cNew SQL Server stand-alone installation or add features do an existing installation\u201d, essa op\u00e7\u00e3o deve ser escolhida caso a instala\u00e7\u00e3o realizada seja stand-alone.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/3.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-67\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/3.jpg?resize=623%2C404\" alt=\"3\" width=\"623\" height=\"404\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/3.jpg?w=622&amp;ssl=1 622w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/3.jpg?resize=300%2C195&amp;ssl=1 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/a><\/li>\n<li>Agora\u00a0escolhemos a edi\u00e7\u00e3o do SQLServer e colocamos o serial de ativa\u00e7\u00e3o do produto.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/4.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-68\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/4.jpg?resize=617%2C428\" alt=\"4\" width=\"617\" height=\"428\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/4.jpg?w=605&amp;ssl=1 605w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/4.jpg?resize=300%2C208&amp;ssl=1 300w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><\/li>\n<li>Aqui \u00e9 o contrato de licen\u00e7a, basta aceitar e continuar com a instala\u00e7\u00e3o.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/5.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-69\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/5.jpg?resize=617%2C424\" alt=\"5\" width=\"617\" height=\"424\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/5.jpg?w=570&amp;ssl=1 570w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/5.jpg?resize=300%2C206&amp;ssl=1 300w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><\/li>\n<li>Se a m\u00eddia n\u00e3o for atualizada, marque essa op\u00e7\u00e3o para baixar as \u00faltimas atualiza\u00e7\u00f5es do SQLServer.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/6.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-70\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/6.jpg?resize=612%2C423\" alt=\"6\" width=\"612\" height=\"423\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/6.jpg?w=570&amp;ssl=1 570w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/6.jpg?resize=300%2C207&amp;ssl=1 300w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><\/li>\n<li>Para fazer uma instala\u00e7\u00e3o personalizada devemos selecionar \u201cSQL Server Feature Installation\u201d, se voc\u00ea deseja fazer a instala\u00e7\u00e3o default voc\u00ea deve selecionar a op\u00e7\u00e3o \u201cAll Features with Defaults\u201d.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/7.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-71\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/7.jpg?resize=610%2C424\" alt=\"7\" width=\"610\" height=\"424\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/7.jpg?w=570&amp;ssl=1 570w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/7.jpg?resize=300%2C208&amp;ssl=1 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/a><\/li>\n<li>Agora devemos escolher quais features ser\u00e3o instaladas.<br \/>\nNeste caso selecionei apenas as features:<\/li>\n<\/ul>\n<p>&#8211; Database Engine Services<\/p>\n<p>&#8211; Client Tools Connectivity<\/p>\n<p>&#8211; Integration Services<\/p>\n<p>&#8211; Management Tools \u2013 Basic<\/p>\n<p>&#8211; Management Tools \u2013 Complete<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/8.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-72\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/8.jpg?resize=602%2C271\" alt=\"8\" width=\"602\" height=\"271\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/8.jpg?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/8.jpg?resize=300%2C134&amp;ssl=1 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n<ul>\n<li>Escolha se deseja\u00a0utilizar uma instancia nomeada ou instancia default \u201cMSSQLSERVER\u201d.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/9.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-73\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/9.jpg?resize=609%2C422\" alt=\"9\" width=\"609\" height=\"422\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/9.jpg?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/9.jpg?resize=300%2C208&amp;ssl=1 300w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><\/li>\n<li>Devemos agora configurar as contas de servi\u00e7os, existe um documento da Microsoft sobre as melhores pr\u00e1ticas para as contas de servi\u00e7os.<br \/>\n<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms144228.aspx\" target=\"_blank\" rel=\"noopener\">https:\/\/msdn.microsoft.com\/en-us\/library\/ms144228.aspx<br \/>\n<\/a><a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/10.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-74\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/10.jpg?resize=607%2C418\" alt=\"10\" width=\"607\" height=\"418\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/10.jpg?w=571&amp;ssl=1 571w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/10.jpg?resize=300%2C206&amp;ssl=1 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/a><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms144228.aspx\" target=\"_blank\" rel=\"noopener\"><br \/>\n<\/a><\/li>\n<\/ul>\n<ul>\n<li>Configure qual a Collation voc\u00ea desse utilizar em sua instancia.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/11.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-75\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/11.jpg?resize=602%2C415\" alt=\"11\" width=\"602\" height=\"415\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/11.jpg?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/11.jpg?resize=300%2C207&amp;ssl=1 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/li>\n<li>Configura\u00e7\u00e3o dos acessos de SA (sysadmin), o SQLServer tem dois tipos de autentica\u00e7\u00f5es, o Windows Authentication e Mixed mode, que permite voc\u00ea utilizar contas do SQLServer como Windows, recomendo a utiliza\u00e7\u00e3o do Mixed mode.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/12.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-76\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/12.jpg?resize=603%2C420\" alt=\"12\" width=\"603\" height=\"420\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/12.jpg?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/12.jpg?resize=300%2C209&amp;ssl=1 300w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/a><\/li>\n<li>Agora vamos fazer os apontamentos dos diret\u00f3rios, eu particularmente recomendo a separa\u00e7\u00e3o dos discos, um disco para dados, um disco para log e um para o tempdb.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/13.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-77\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/13.jpg?resize=603%2C420\" alt=\"13\" width=\"603\" height=\"420\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/13.jpg?w=566&amp;ssl=1 566w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/13.jpg?resize=300%2C209&amp;ssl=1 300w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/a><\/li>\n<\/ul>\n<ul>\n<li>Se voc\u00ea for utilizar o recurso de filestream voc\u00ea j\u00e1 pode habilitar aqui, ou pode habilitar mais tarde.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/14.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-78\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/14.jpg?resize=602%2C415\" alt=\"14\" width=\"602\" height=\"415\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/14.jpg?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/14.jpg?resize=300%2C207&amp;ssl=1 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/li>\n<li>Aqui \u00e9 mostrado um resumo da nossa instala\u00e7\u00e3o.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/15.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-79\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/15.jpg?resize=601%2C417\" alt=\"15\" width=\"601\" height=\"417\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/15.jpg?w=568&amp;ssl=1 568w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/15.jpg?resize=300%2C208&amp;ssl=1 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/li>\n<li>Progresso da instala\u00e7\u00e3o.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/16.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-80\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/16.jpg?resize=598%2C413\" alt=\"16\" width=\"598\" height=\"413\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/16.jpg?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/16.jpg?resize=300%2C207&amp;ssl=1 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/a><\/li>\n<\/ul>\n<ul>\n<li>Resultado da instala\u00e7\u00e3o, se tivesse ocorrido algum erro na instala\u00e7\u00e3o seria mostrado aqui.<br \/>\n<a href=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/17.jpg\" target=\"_blank\"  rel=\"lightbox[62] noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-81\" src=\"https:\/\/i0.wp.com\/tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/17.jpg?resize=598%2C414\" alt=\"17\" width=\"598\" height=\"414\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/17.jpg?w=568&amp;ssl=1 568w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/17.jpg?resize=300%2C207&amp;ssl=1 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/a><\/li>\n<\/ul>\n<p>Bom pessoal por hoje \u00e9 s\u00f3.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 requisitos de hardware e software&#8230;<\/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","_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":false,"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":[16,5],"tags":[18,19,17,14],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-sqlserver-2014","category-virtual-pass-br","tag-install","tag-installsqlserver","tag-sql2014","tag-sqlserver"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6eIyh-10","jetpack-related-posts":[{"id":106,"url":"https:\/\/www.tiagoneves.net\/blog\/falha-ao-iniciar-servico-do-sqlserver-2014\/","url_meta":{"origin":62,"position":0},"title":"Falha ao iniciar servi\u00e7o do SQLServer 2014","author":"tiagoneves","date":"19 de maio de 2015","format":false,"excerpt":"Fala pessoal tudo certo? Hoje vou postar sobre um erro que aconteceu comigo ontem (18\/05), bom estou montando um ambiente de homologa\u00e7\u00e3o do SQLServer 2014 na empresa em que trabalho, depois de fazer toda a instala\u00e7\u00e3o, importa\u00e7\u00e3o dos usu\u00e1rios, configura\u00e7\u00e3o dos linkedserver\u2019s, importa\u00e7\u00e3o dos job\u2019s e restore de quase 2TB\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":"Capture","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/Capture.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/Capture.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/Capture.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/Capture.jpg?resize=700%2C400 2x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/05\/Capture.jpg?resize=1050%2C600 3x"},"classes":[]},{"id":664,"url":"https:\/\/www.tiagoneves.net\/blog\/instalando-o-sql-server-2016-e-o-management-studio\/","url_meta":{"origin":62,"position":1},"title":"Instalando o SQL Server 2016 e o Management Studio","author":"tiagoneves","date":"5 de julho de 2016","format":false,"excerpt":"Ol\u00e1 pessoal, tudo certo? Neste post, demonstrarei como fazer a instala\u00e7\u00e3o stand-alone do SQL Server 2016. Ele segue o mesmo padr\u00e3o das outras vers\u00f5es do SQL Server, por\u00e9m agora, temos alguns pontos novos que devemos nos atentar. Portanto, se voc\u00ea que ainda n\u00e3o fez a instala\u00e7\u00e3o do SQL Server, espero\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":"Install_SQLSERVER2016_ERROR_CONFIGURATION","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/07\/Install_SQLSERVER2016_ERROR_CONFIGURATION.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/07\/Install_SQLSERVER2016_ERROR_CONFIGURATION.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/07\/Install_SQLSERVER2016_ERROR_CONFIGURATION.png?resize=525%2C300 1.5x"},"classes":[]},{"id":2352,"url":"https:\/\/www.tiagoneves.net\/blog\/alwayson-boas-praticas-para-instalar-o-cumulative-update\/","url_meta":{"origin":62,"position":2},"title":"AlwaysOn &#8211; Boas Pr\u00e1ticas para instalar o Cumulative Update","author":"tiagoneves","date":"2 de julho de 2020","format":false,"excerpt":"Ol\u00e1 pessoal tudo certo? No post de hoje vou falar um pouco mais sobre o SQL Server AlwaysOn, onde vi em alguns f\u00f3runs uma d\u00favida bem comum: \u201cQual \u00e9 a melhor forma de atualizar o SQL Server em um ambiente com o AlwaysOn habilitado?\u201d Mas antes, se voc\u00ea quiser ver\u2026","rel":"","context":"Em &quot;High Availability&quot;","block_context":{"text":"High Availability","link":"https:\/\/www.tiagoneves.net\/blog\/category\/high-availability\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/06\/image-12.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/06\/image-12.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/06\/image-12.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2020\/06\/image-12.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":527,"url":"https:\/\/www.tiagoneves.net\/blog\/boa-noticia-da-semana-sql-server-2014-developer-agora-e-free\/","url_meta":{"origin":62,"position":3},"title":"Boa noticia da semana &#8211; SQL Server 2014 Developer agora \u00e9 free","author":"tiagoneves","date":"1 de abril de 2016","format":false,"excerpt":"Bom dia pessoal, A Microsoft nos deu um presente, a partir de agora a edi\u00e7\u00e3o Developer do SQL Server 2014 \u00e9 free, ou seja agora voc\u00ea pode instalar uma edi\u00e7\u00e3o completa do SQL Server com todas as features no seu computador, sem precisar pagar os U$$ 50,00 pela licen\u00e7a, se\u2026","rel":"","context":"Em &quot;Microsoft&quot;","block_context":{"text":"Microsoft","link":"https:\/\/www.tiagoneves.net\/blog\/category\/microsoft\/"},"img":{"alt_text":"Visual_Studio_Dev_Essentials","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/04\/Visual_Studio_Dev_Essentials.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/04\/Visual_Studio_Dev_Essentials.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/04\/Visual_Studio_Dev_Essentials.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/04\/Visual_Studio_Dev_Essentials.png?resize=700%2C400 2x"},"classes":[]},{"id":809,"url":"https:\/\/www.tiagoneves.net\/blog\/sql-server-on-linux-parte-2\/","url_meta":{"origin":62,"position":4},"title":"SQL Server on Linux &#8211; Parte 2","author":"tiagoneves","date":"19 de dezembro de 2016","format":false,"excerpt":"Ol\u00e1 pessoal, tudo certo? Continuando o post anterior sobre o SQL Server vNext, hoje vou demonstrar como fazer a instala\u00e7\u00e3o do SQL Server na distribui\u00e7\u00e3o Centos 7. Neste post n\u00e3o vou abordar como fazer a instala\u00e7\u00e3o do Linux, pois eu fa\u00e7o a instala\u00e7\u00e3o b\u00e1sica, afinal eu n\u00e3o sei nada de\u2026","rel":"","context":"Em &quot;Microsoft&quot;","block_context":{"text":"Microsoft","link":"https:\/\/www.tiagoneves.net\/blog\/category\/microsoft\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2016\/12\/LinuxLove.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":468,"url":"https:\/\/www.tiagoneves.net\/blog\/atualizando-o-windows-server-de-um-cluster-sql-server\/","url_meta":{"origin":62,"position":5},"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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/62","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=62"}],"version-history":[{"count":1,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":82,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/62\/revisions\/82"}],"wp:attachment":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}