Início / dba / Perguntas / 339624
Accepted
guradio
Asked: 2024-05-19 16:36:50 +0800 CST

Falha na instalação/reparo do SQL Server

  • 772

Estou instalando uma instância local do SQL Server.

Durante a configuração, o mecanismo do banco de dados falha. Quais outras etapas podem garantir que a instalação seja bem-sucedida?

O que eu tentei:

  1. Instalando duas vezes.
  2. Reparando a instalação duas vezes.
  3. Desativando o firewall.
  4. Executando a instalação como administrador.
  5. O mecanismo do banco de dados continua falhando. E o serviço do SQL Server falha ao iniciar.

Estou correto em supor que isso falha porque o serviço do SQL Server não pode ser iniciado porque o mecanismo de banco de dados não está instalado?

insira a descrição da imagem aqui insira a descrição da imagem aqui insira a descrição da imagem aqui insira a descrição da imagem aqui insira a descrição da imagem aqui

Detailed results:
  Feature:                       Master Data Services
  Status:                        Passed

  Feature:                       Database Engine Services
  Status:                        Failed
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.

2024-05-12 00:10:43.24 Server      Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 
    Oct  8 2022 05:58:25 
    Copyright (C) 2022 Microsoft Corporation
    Developer Edition (64-bit) on Windows 10 Home Single Language 10.0 <X64> (Build 22631: ) (Hypervisor)

2024-05-12 00:10:43.24 Server      UTC adjustment: 8:00
2024-05-12 00:10:43.24 Server      (c) Microsoft Corporation.
2024-05-12 00:10:43.24 Server      All rights reserved.
2024-05-12 00:10:43.24 Server      Server process ID is 119848.
2024-05-12 00:10:43.24 Server      System Manufacturer: 'ASUSTeK COMPUTER INC.', System Model: 'ROG Strix G513QC_G513QC'.
2024-05-12 00:10:43.24 Server      Authentication mode is WINDOWS-ONLY.
2024-05-12 00:10:43.24 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.LOCALSQLSERVER\MSSQL\Log\ERRORLOG'.
2024-05-12 00:10:43.24 Server      The service account is 'NT Service\MSSQL$LOCALSQLSERVER'. This is an informational message; no user action is required.
2024-05-12 00:10:43.24 Server      Registry startup parameters: 
     -d C:\Program Files\Microsoft SQL Server\MSSQL16.LOCALSQLSERVER\MSSQL\DATA\master.mdf
     -e C:\Program Files\Microsoft SQL Server\MSSQL16.LOCALSQLSERVER\MSSQL\Log\ERRORLOG
     -l C:\Program Files\Microsoft SQL Server\MSSQL16.LOCALSQLSERVER\MSSQL\DATA\mastlog.ldf
2024-05-12 00:10:43.24 Server      Command Line Startup Parameters:
     -s "LOCALSQLSERVER"
     -m "SqlSetup"
     -Q
     -q "SQL_Latin1_General_CP1_CI_AS"
     -T 4022
     -T 4010
     -T 3659
     -T 3610
     -T 8015
2024-05-12 00:10:43.24 Server      SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2024-05-12 00:10:43.24 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2024-05-12 00:10:43.24 Server      Detected 32158 MB of RAM. This is an informational message; no user action is required.
2024-05-12 00:10:43.24 Server      Using conventional memory in the memory manager.
2024-05-12 00:10:43.24 Server      Detected pause instruction latency: 65 cycles.
2024-05-12 00:10:43.24 Server      Spin divider value used: 1
2024-05-12 00:10:43.24 Server      Page exclusion bitmap is enabled.
2024-05-12 00:10:43.40 Server      Buffer Pool: Allocating 1048576 bytes for 833096 hashPages.
2024-05-12 00:10:43.40 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2024-05-12 00:10:43.42 Server      Buffer pool extension is already disabled. No action is necessary.
2024-05-12 00:10:43.44 Server      CPU vectorization level(s) detected:  SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2
2024-05-12 00:10:43.44 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2024-05-12 00:10:43.46 Server      Query Store settings initialized with enabled = 1, 
2024-05-12 00:10:43.46 Server      The maximum number of dedicated administrator connections for this instance is '1'
2024-05-12 00:10:43.46 Server      This instance of SQL Server last reported using a process ID of 117212 at 12/05/2024 12:10:41 am (local) 11/05/2024 4:10:41 pm (UTC). This is an informational message only; no user action is required.
2024-05-12 00:10:43.46 Server      Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2024-05-12 00:10:43.47 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2024-05-12 00:10:43.47 Server      Lock partitioning is enabled.  This is an informational message only. No user action is required.
2024-05-12 00:10:43.47 Server      In-Memory OLTP initialized on lowend machine.
2024-05-12 00:10:43.48 Server      [INFO] Created Extended Events session 'hkenginexesession'
2024-05-12 00:10:43.48 Server      Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2024-05-12 00:10:43.48 Server      Total Log Writer threads: 2, Node CPUs: 8, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2024-05-12 00:10:43.50 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2024-05-12 00:10:43.50 Server      clwb is selected for pmem flush operation.
2024-05-12 00:10:43.50 spid42s     Warning ******************
2024-05-12 00:10:43.50 spid42s     SQL Server started in single-user mode. This an informational message only. No user action is required.
2024-05-12 00:10:43.50 Server      Software Usage Metrics is disabled.
2024-05-12 00:10:43.50 spid42s     Starting up database 'master'.
2024-05-12 00:10:43.51 spid42s     There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.LOCALSQLSERVER\MSSQL\DATA\master.mdf.
2024-05-12 00:10:43.51 spid42s     05/12/24 00:10:43 Stack Overflow Dump not possible - Exception c00000fd EXCEPTION_STACK_OVERFLOW at 0x00007FFE0AA1F009
2024-05-12 00:10:43.51 spid42s     SqlDumpExceptionHandler: Address=0x00007FFE0AA1F009 Exception Code = c00000fd
2024-05-12 00:10:43.51 spid42s     Rax=0000000000001118 Rbx=00000000fb49a180 Rcx=000000000741e040 Rdx=0000000008099000
2024-05-12 00:10:43.51 spid42s     Rsi=0000000008099000 Rdi=0000000000004000 Rip=000000000aa1f009 Rsp=000000004c613060
2024-05-12 00:10:43.51 spid42s     Rbp=000000004c612060 EFlags=0000000000010206
2024-05-12 00:10:43.51 spid42s     cs=0000000000000033 ss=000000000000002b ds=000000000000002b
es=000000000000002b fs=0000000000000053 gs=000000000000002b
2024-05-12 00:10:43.57 Server      CLR version v4.0.30319 loaded.
2024-05-12 00:10:43.61 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2024-05-12 00:10:43.62 spid42s     Frame 0: 0x00007FFE07D95F16
2024-05-12 00:10:43.62 spid42s     Frame 1: 0x00007FFE08CCD6B6
2024-05-12 00:10:43.62 spid42s     Frame 2: 0x00007FFE07D958A0
2024-05-12 00:10:43.62 spid42s     Frame 3: 0x00007FFE10539C16
2024-05-12 00:10:43.62 spid42s     Frame 4: 0x00007FFE104D4BDC
2024-05-12 00:10:43.62 spid42s     Frame 5: 0x00007FFE104D4E5B
2024-05-12 00:10:43.62 spid42s     Frame 6: 0x00007FFED89DF8F5
2024-05-12 00:10:43.62 spid42s     Frame 7: 0x00007FFED89D3DA0
2024-05-12 00:10:43.62 spid42s     Frame 8: 0x00007FFED89D37A1
2024-05-12 00:10:43.62 spid42s     Frame 9: 0x00007FFED89D46EC
2024-05-12 00:10:43.62 spid42s     Frame 10: 0x00007FFED89E04B1
2024-05-12 00:10:43.62 spid42s     Frame 11: 0x00007FFEF347440F
2024-05-12 00:10:43.62 spid42s     Frame 12: 0x00007FFEF33EE466
2024-05-12 00:10:43.62 spid42s     Frame 13: 0x00007FFEF34733FE
2024-05-12 00:10:43.62 spid42s     Frame 14: 0x00007FFE0AA1F009
2024-05-12 00:10:43.62 spid42s     Frame 15: 0x00007FFE0BBBA79F
2024-05-12 00:10:43.62 spid42s     
2024-05-12 00:10:43.62 spid42s     TotalPhysicalMemory = 33720791040, AvailablePhysicalMemory = 10920484864
2024-05-12 00:10:43.62 spid42s     AvailableVirtualMemory = 140692328562688, AvailablePagingFile = 5082546176
2024-05-12 00:10:43.62 spid42s     Stack Signature for the dump is 0x00000000CFAEA995
2024-05-12 00:10:44.25 spid42s     External dump process return code 0x20000001.
External dump process returned no errors.

2024-05-12 00:10:44.27 spid42s     Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2024-05-12 00:10:44.27 spid42s     Stack Signature for the dump is 0x0000000000000000
2024-05-12 00:10:44.27 spid42s     CDmpClient::ExecuteAllCallbacks started.
2024-05-12 00:10:44.27 spid42s     XE_DumpCallbacks is executing...
2024-05-12 00:10:44.28 spid42s     DumpCallbackSOS is executing...
2024-05-12 00:10:44.28 spid42s     DumpCallbackEE is executing...
2024-05-12 00:10:44.28 spid42s     DumpCallbackSE is executing...
2024-05-12 00:10:44.28 spid42s     DumpCallbackSEAM is executing...
2024-05-12 00:10:44.28 spid42s     DumpCallbackSSB is executing...
2024-05-12 00:10:44.30 spid42s     DumpCallbackQE is executing...
2024-05-12 00:10:44.30 spid42s     DumpCallbackFullText is executing...
2024-05-12 00:10:44.30 spid42s     DumpCallbackSQLCLR is executing...
2024-05-12 00:10:44.30 spid42s     DumpCallbackHk is executing...
2024-05-12 00:10:44.30 spid42s     DumpCallbackRepl is executing...
2024-05-12 00:10:44.30 spid42s     DumpCallbackPolyBase is executing...
2024-05-12 00:10:44.30 spid42s     CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2024-05-12 00:10:44.95 spid42s     External dump process return code 0x20000001.
External dump process returned no errors.

Atualizar :

C:\Windows\System32>fsutil fsinfo ntfsinfo C:
NTFS Volume Serial Number :        0x62906c9f906c7c03
NTFS Version      :                3.1
LFS Version       :                2.0
Total Sectors     :                950,846,094  (453.4 GB)
Total Clusters    :                118,855,761  (453.4 GB)
Free Clusters     :                 57,541,365  (219.5 GB)
Total Reserved Clusters :              663,939  (  2.5 GB)
Reserved For Storage Reserve :         655,360  (  2.5 GB)
Bytes Per Sector  :                512
Bytes Per Physical Sector :        4096
Bytes Per Cluster :                4096  (4 KB)
Bytes Per FileRecord Segment    :  1024
Clusters Per FileRecord Segment :  0
Mft Valid Data Length :            1.23 GB
Mft Start Lcn  :                   0x00000000000c0000
Mft2 Start Lcn :                   0x0000000000000002
Mft Zone Start :                   0x0000000004878280
Mft Zone End   :                   0x000000000487fc00
MFT Zone Size  :                   121.50 MB
Max Device Trim Extent Count :     256
Max Device Trim Byte Count :       0xffffffff
Max Volume Trim Extent Count :     62
Max Volume Trim Byte Count :       0x40000000
Resource Manager Identifier :      955798FB-21A8-11EC-9FBF-04421AD07687
sql-server

1 respostas

  1. Best Answer

    A unidade está formatada incorretamente para o SQL Server:

    2024-05-12 00:10:43.51 spid42s     There have been 256 misaligned log IOs which 
                                   required falling back to synchronous IO.  
                                   The current IO is on file C:\Program Files\
                                   Microsoft SQL Server\MSSQL16.LOCALSQLSERVER\
                                   MSSQL\DATA\master.mdf.

    Bytes Per Sector  :                512
Bytes Per Physical Sector :        4096

    Reformate-o com clusters de 4 KB e reinstale o Windows. Ou crie uma nova unidade D:e formate, depois defina o local do banco de dados do SQL Server para isso.

    Política de suporte da Microsoft para discos rígidos de setor 4K no Windows.

    • 2

relate perguntas