Server 2019无法启动(sqllang.dll)

Question

我正在运行Windows 11的新安装，试图设置本地SQL服务器进行开发。

我从ISO安装了SQL server 2019，但是无法启动服务器。同样的安装方法和ISO在我的Windows 10机器上工作得很好。

我在网上搜索过，也看到过类似的问题。然而，一直未能找到解决办法或解决办法。

事件查看器中的

错误：

Faulting application name: sqlservr.exe, version: 2019.150.2000.5, time stamp: 0x5d8a9215
Faulting module name: sqllang.dll, version: 2019.150.2000.5, time stamp: 0x5d8a92a9
Exception code: 0xc0000005
Fault offset: 0x0000000000310093
Faulting process id: 0x48a4
Faulting application start time: 0x01d7becf32875804
Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
Faulting module path: C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\sqllang.dll
Report Id: 14e3b7c3-b920-45c5-b60b-14054875a8f4
Faulting package full name: 
Faulting package-relative application ID: 

错误转储：

Fault bucket 1333523691806522765, type 4
Event Name: APPCRASH
Response: Not available
Cab Id: 0

Problem signature:
P1: sqlservr.exe
P2: 2019.150.2000.5
P3: 5d8a9215
P4: sqllang.dll
P5: 2019.150.2000.5
P6: 5d8a92a9
P7: c0000005
P8: 0000000000310093
P9: 
P10: 

SQL SERVER错误日志：

2021-10-11 14:38:34.74 Server      Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) 
    Sep 24 2019 13:48:23 
    Copyright (C) 2019 Microsoft Corporation
    Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22000: )

2021-10-11 14:38:34.74 Server      UTC adjustment: -4:00
2021-10-11 14:38:34.74 Server      (c) Microsoft Corporation.
2021-10-11 14:38:34.74 Server      All rights reserved.
2021-10-11 14:38:34.74 Server      Server process ID is 18596.
2021-10-11 14:38:34.74 Server      System Manufacturer: 'Gigabyte Technology Co., Ltd.', System Model: 'B450 AORUS PRO WIFI'.
2021-10-11 14:38:34.74 Server      Authentication mode is WINDOWS-ONLY.
2021-10-11 14:38:34.74 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2021-10-11 14:38:34.74 Server      The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2021-10-11 14:38:34.74 Server      Registry startup parameters: 
     -d C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf
     -e C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG
     -l C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2021-10-11 14:38:34.74 Server      Command Line Startup Parameters:
     -s "MSSQLSERVER"
2021-10-11 14:38:34.74 Server      SQL Server detected 1 sockets with 6 cores per socket and 12 logical processors per socket, 12 total logical processors; using 12 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2021-10-11 14:38:34.74 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2021-10-11 14:38:34.74 Server      Detected 16332 MB of RAM. This is an informational message; no user action is required.
2021-10-11 14:38:34.74 Server      Using conventional memory in the memory manager.
2021-10-11 14:38:34.74 Server      Page exclusion bitmap is enabled.
2021-10-11 14:38:34.84 Server      Buffer Pool: Allocating 1048576 bytes for 663038 hashPages.
2021-10-11 14:38:34.85 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2021-10-11 14:38:34.86 Server      Buffer pool extension is already disabled. No action is necessary.
2021-10-11 14:38:34.89 Server      Query Store settings initialized with enabled = 1, 
2021-10-11 14:38:34.89 Server      The maximum number of dedicated administrator connections for this instance is '1'
2021-10-11 14:38:34.89 Server      This instance of SQL Server last reported using a process ID of 17260 at 10/11/2021 2:36:41 PM (local) 10/11/2021 6:36:41 PM (UTC). This is an informational message only; no user action is required.
2021-10-11 14:38:34.89 Server      Node configuration: node 0: CPU mask: 0x0000000000000fff:0 Active CPU mask: 0x0000000000000fff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2021-10-11 14:38:34.89 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.
2021-10-11 14:38:34.90 Server      In-Memory OLTP initialized on lowend machine.
2021-10-11 14:38:34.90 Server      [INFO] Created Extended Events session 'hkenginexesession'

2021-10-11 14:38:34.90 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.
2021-10-11 14:38:34.91 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2021-10-11 14:38:34.91 Server      clwb is selected for pmem flush operation.
2021-10-11 14:38:34.91 Server      Software Usage Metrics is disabled.
2021-10-11 14:38:34.91 spid9s      Starting up database 'master'.
2021-10-11 14:38:34.92 spid9s      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\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf.
2021-10-11 14:38:35.03 Server      CLR version v4.0.30319 loaded.
2021-10-11 14:38:35.08 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.

Answer 1

它看起来只是需要安装在第二个磁盘上，奇怪，但我试过了，它只是工作。

基本上，你有两个选择：

• 将实例安装在第二个磁盘上，并将共享组件保留在磁盘C上(它应该是灰色的，因此这里甚至没有选项)
• 在WSL2下的linux容器(docker)中安装Server 2019

我尝试了第一个选项，它成功了，我的同事尝试了使用docker和WSL2的第二个选项，它也有效。

资料来源及更多资料：Windows 11上的微软2019