Symptoms
Assume that you try to install Microsoft SQL Server 2019 on a Linux operating system such as Redhat or Ubuntu. If IPv6 is disabled at the OS kernel level, and you try to configure SQL Server by using the "sudo /opt/mssql/bin/mssql-conf setup" command, you receive the following messages in the Linux console and SQL Server error log. Additionally, the configuration may fail.
Linux console:
The licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition].
ForceFlush is enabled for this instance.
ForceFlush feature is enabled for log durability.
Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG
in /var/opt/mssql/log for more information.
SQL Server error log:
DateTimeAndSpid Clearing tempdb database.
DateTimeAndS pid [2]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
DateTimeAndS pid Starting up database 'tempdb'.
DateTimeAndS pid The tempdb database has 1 data file(s).
DateTimeAndS pid The Service Broker endpoint is in disabled or stopped state.
DateTimeAndS pid The Database Mirroring endpoint is in disabled or stopped state.
DateTimeAndS pid Service Broker manager has started.
DateTimeAndS pid Database 'msdb' running the upgrade step from version VersionNum to version VersionNum.
DateTimeAndS pid Database 'msdb' running the upgrade step from version VersionNum to version VersionNum.
DateTimeAndS pid Error: 26024, Severity: 16, State: 1.
DateTimeAndS pid Server failed to listen on 'any' <ipv6> 1433. Error: 0x2742. To proceed, notify your system administrator.
DateTimeAndS pid Error: 17182, Severity: 16, State: 1.
DateTimeAndS pid TDSSNIClient initialization failed with error 0x2742, status code 0xa. Reason: Unable to initialize the TCP/IP listener. A socket operation encountered a dead network.
DateTimeAndS pid Error: 17182, Severity: 16, State: 1.
DateTimeAndS pid TDSSNIClient initialization failed with error 0x2742, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. A socket operation encountered a dead network.
DateTimeAndS pid Error: 39002, Severity: 16, State: 1.
DateTimeAndS pid SQL failed to boot extensibility for error code 0x80070005.
DateTimeAndS pid Error: 17826, Severity: 18, State: 3.
DateTimeAndS pid Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
DateTimeAndS pid Error: 17120, Severity: 16, State: 1.
DateTimeAndS pid SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.
Resolution
This issue is fixed in the following cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Workaround
To work around the issue, run the following command:
sudo MSSQL_IP_ADDRESS=0.0.0.0 /opt/mssql/bin/mssql-conf setup
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminologythat Microsoft uses to describe software updates.
