{"id":467,"date":"2024-05-25T17:21:59","date_gmt":"2024-05-25T20:21:59","guid":{"rendered":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/"},"modified":"2024-05-25T17:33:22","modified_gmt":"2024-05-25T20:33:22","slug":"preparar-para-instalar-mssql","status":"publish","type":"docs","link":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/","title":{"rendered":"Preparar para instalar MSSQL"},"content":{"rendered":"\n<p>O Scritp abaixo foi usado para corrigir alguns problemas de repara\u00e7\u00e3o\/instala\u00e7\u00e3o do MSSQL (2022).<br>Importante reiniciar o PC logo depois de executar o script em modo administrador.<br><\/p>\n\n\n\n<pre class=\"wp-block-code has-cyan-bluish-gray-color has-black-background-color has-text-color has-background has-link-color wp-elements-92d5754b2e64db47b1abf7bafa5748f0\"><code>@echo off\nsetLocal\n\nrem CORRIGIR ERRO DE CONEXAO APOS A INSTALACAO (ERRO COMUM NO WINDOWS 10)\nREG ADD \"HKLM\\SYSTEM\\CurrentControlSet\\Services\\stornvme\\Parameters\\Device\" \/v \"ForcedPhysicalSectorSizeInBytes\" \/t   REG_MULTI_SZ\u00a0\/d\u00a0\"*\u00a04095\"\u00a0\/f\n\n\nrem CORRIGE ERRO DE \"CLUSTER INICIADO E ONLINE\" \nrewm (COSTUMA ACONTECER NO COMANDO REPARAR)\n\necho Verificando o servi\u00e7o de cluster...\nsc query ClusSvc | findstr \/I \/C:\"RUNNING\"\nif %ERRORLEVEL% NEQ 0 (\n    echo O servi\u00e7o de cluster nao esta em execucao. Iniciando o servico...\n    net start ClusSvc\n    if %ERRORLEVEL% NEQ 0 (\n        echo Falha ao iniciar o servico de cluster.\n        goto end\n    )\n    echo Servico de cluster iniciado com sucesso.\n) else (\n    echo O servico de cluster ja esta em execucao.\n)\n\nrem Verificar o estado do recurso do SQL Server no cluster\necho Verificando o estado do recurso do SQL Server no cluster...\npowershell -Command \"Get-ClusterResource | Where-Object { $_.Name -like '*SQL Server*' } | ForEach-Object { $_.State }\" | findstr \/I \/C:\"Online\"\nif %ERRORLEVEL% NEQ 0 (\n    echo O recurso do SQL Server nao esta online. Trazendo-o online...\n    powershell -Command \"Get-ClusterResource | Where-Object { $_.Name -like '*SQL Server*' } | ForEach-Object { Start-ClusterResource $_ }\"\n    if %ERRORLEVEL% NEQ 0 (\n        echo Falha ao trazer o recurso do SQL Server online.\n        goto end\n    )\n    echo Recurso do SQL Server trazido online com sucesso.\n) else (\n    echo O recurso do SQL Server ja esta online.\n)\n\n:end\necho Script concluido.\nendlocal\npause\n\n\n@echo off\nsetlocal\n\nrem PREPARA PRE REQUISITOS PARA A INSTALA\u00c7\u00c3O.\necho Verificando requisitos de instala\u00e7\u00e3o do SQL Server...\n\nrem Verificar se o .NET Framework est\u00e1 instalado\necho Verificando .NET Framework...\nreg query \"HKLM\\SOFTWARE\\Microsoft\\NET Framework Setup\\NDP\\v4\\Full\" \/v Release >nul 2>&amp;1\nif %ERRORLEVEL% NEQ 0 (\n    echo .NET Framework 4.5 ou superior nao esta instalado.\n    echo Por favor, instale o .NET Framework e tente novamente.\n    goto end\n) else (\n    echo .NET Framework 4.5 ou superior encontrado.\n)\n\nrem Verificar se h\u00e1 atualiza\u00e7\u00f5es do Windows pendentes\necho Verificando atualizacoes do Windows...\nwmic qfe list brief \/format:table | findstr \/I \/C:\"KB\"\nif %ERRORLEVEL% NEQ 0 (\n    echo Nao foi possivel verificar atualizacoes do Windows. Por favor, verifique manualmente.\n) else (\n    echo Atualizacoes do Windows verificadas.\n)\n\nrem Executar o verificador de arquivos do sistema\necho Executando o verificador de arquivos do sistema...\nsfc \/scannow\nif %ERRORLEVEL% NEQ 0 (\n    echo Ocorreu um erro ao executar o verificador de arquivos do sistema.\n    goto end\n) else (\n    echo Verificacao de arquivos do sistema concluida.\n)\n\necho Pronto para tentar instalar o SQL Server novamente.\n:end\npause\nendlocal\n@echo off\nsetlocal\n\necho Verificando e reparando o WMI...\n\nrem Parar o servi\u00e7o WMI\nnet stop winmgmt \/y\n\nrem Renomear o reposit\u00f3rio WMI\nif exist C:\\Windows\\System32\\wbem\\repository.old (\n    echo Repositorio WMI ja renomeado anteriormente.\n) else (\n    rename C:\\Windows\\System32\\wbem\\repository repository.old\n)\n\nrem Reiniciar o servi\u00e7o WMI\nnet start winmgmt\n\nrem Recompilar os arquivos MOF e MFL\ncd \/d C:\\Windows\\System32\\wbem\nfor %%s in (*.mof) do mofcomp %%s\nfor %%s in (*.mfl) do mofcomp %%s\n\necho Repositorio WMI reparado com sucesso.\n\nrem Verificar e reparar o .NET Framework\necho Verificando o .NET Framework...\n\nreg query \"HKLM\\SOFTWARE\\Microsoft\\NET Framework Setup\\NDP\\v4\\Full\" \/v Release >nul 2>&amp;1\nif %ERRORLEVEL% NEQ 0 (\n    echo .NET Framework 4.5 ou superior nao esta instalado.\n    echo Por favor, instale o .NET Framework e tente novamente.\n    goto end\n) else (\n    echo .NET Framework 4.5 ou superior encontrado.\n)\n\nrem Pronto para tentar instalar o SQL Server novamente\n:end\necho Script concluido.\npause\nendlocal\n<\/code><\/pre>\n","protected":false},"featured_media":0,"parent":466,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-467","docs","type-docs","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Preparar para instalar MSSQL - Blog Select One<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Preparar para instalar MSSQL - Blog Select One\" \/>\n<meta property=\"og:description\" content=\"O Scritp abaixo foi usado para corrigir alguns problemas de repara\u00e7\u00e3o\/instala\u00e7\u00e3o do MSSQL (2022).Importante reiniciar o PC logo depois de executar o script em modo administrador.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Select One\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/selectonetecnologia\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-25T20:33:22+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/scripts-e-querys\\\/preparar-para-instalar-mssql\\\/\",\"url\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/scripts-e-querys\\\/preparar-para-instalar-mssql\\\/\",\"name\":\"Preparar para instalar MSSQL - Blog Select One\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/#website\"},\"datePublished\":\"2024-05-25T20:21:59+00:00\",\"dateModified\":\"2024-05-25T20:33:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/scripts-e-querys\\\/preparar-para-instalar-mssql\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/scripts-e-querys\\\/preparar-para-instalar-mssql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/scripts-e-querys\\\/preparar-para-instalar-mssql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BASE DE CONHECIMENTOS\",\"item\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Scripts e Querys\",\"item\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/docs\\\/base-de-conhecimentos\\\/scripts-e-querys\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Preparar para instalar MSSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/\",\"name\":\"Blog Select One Tecnologia\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/#organization\",\"name\":\"Select One Tecnologia\",\"url\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo.png\",\"width\":1140,\"height\":1140,\"caption\":\"Select One Tecnologia\"},\"image\":{\"@id\":\"https:\\\/\\\/selectone.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/selectonetecnologia\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Preparar para instalar MSSQL - Blog Select One","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/","og_locale":"pt_PT","og_type":"article","og_title":"Preparar para instalar MSSQL - Blog Select One","og_description":"O Scritp abaixo foi usado para corrigir alguns problemas de repara\u00e7\u00e3o\/instala\u00e7\u00e3o do MSSQL (2022).Importante reiniciar o PC logo depois de executar o script em modo administrador.","og_url":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/","og_site_name":"Blog Select One","article_publisher":"https:\/\/www.facebook.com\/selectonetecnologia","article_modified_time":"2024-05-25T20:33:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/","url":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/","name":"Preparar para instalar MSSQL - Blog Select One","isPartOf":{"@id":"https:\/\/selectone.com.br\/blog\/#website"},"datePublished":"2024-05-25T20:21:59+00:00","dateModified":"2024-05-25T20:33:22+00:00","breadcrumb":{"@id":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/preparar-para-instalar-mssql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/selectone.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"BASE DE CONHECIMENTOS","item":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/"},{"@type":"ListItem","position":3,"name":"Scripts e Querys","item":"https:\/\/selectone.com.br\/blog\/docs\/base-de-conhecimentos\/scripts-e-querys\/"},{"@type":"ListItem","position":4,"name":"Preparar para instalar MSSQL"}]},{"@type":"WebSite","@id":"https:\/\/selectone.com.br\/blog\/#website","url":"https:\/\/selectone.com.br\/blog\/","name":"Blog Select One Tecnologia","description":"","publisher":{"@id":"https:\/\/selectone.com.br\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/selectone.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/selectone.com.br\/blog\/#organization","name":"Select One Tecnologia","url":"https:\/\/selectone.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/selectone.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/selectone.com.br\/blog\/wp-content\/uploads\/2020\/06\/logo.png","contentUrl":"https:\/\/selectone.com.br\/blog\/wp-content\/uploads\/2020\/06\/logo.png","width":1140,"height":1140,"caption":"Select One Tecnologia"},"image":{"@id":"https:\/\/selectone.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/selectonetecnologia"]}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/docs\/467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/comments?post=467"}],"version-history":[{"count":1,"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/docs\/467\/revisions"}],"predecessor-version":[{"id":469,"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/docs\/467\/revisions\/469"}],"up":[{"embeddable":true,"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/docs\/466"}],"wp:attachment":[{"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/media?parent=467"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/selectone.com.br\/blog\/wp-json\/wp\/v2\/doc_tag?post=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}