SQL Server 2019 Launchpad "Security Context Manager initialization failed"

vom Hau, Marco 21 Reputation points
2023-05-04T12:25:55.8433333+00:00

Hello,

we installed a new SQL Server 2019 on a Windows Server 2019 Cluster and we are not able to get the SQL Server Launchpad Service to start. The sql server and the launchpad service are also set up as cluster ressources.

On an other non-cluster server in the same domain the launchpad service starts.

In the EXTLAUNCHERRORLOG (EXTLAUNCHERRORLOG.log) are the following errors:

2023-05-04 12:31:56.957 Security Context Manager initialization failed. ErrorCode: 0x80070002.

2023-05-04 12:31:56.959 Satellite Session Manager initialization failed. ErrorCode: 0x80070002.

2023-05-04 12:31:56.959 Initialization of satellite session manager failed. ErrorCode: 0x80070002.

In the windows application log are no entries.

In the windows security log are no audit failures.

The launchpad service is running under the account "NT Service\MSSQLLaunchpad"

This account has these privileges on both nodes via global policies

  • Log on as a service (SeServiceLogonRight)
  • Replace a process-level token (SeAssignPrimaryTokenPrivilege)
  • Bypass traverse checking (SeChangeNotifyPrivilege)
  • Adjust memory quotas for a process (SeIncreaseQuotaSizePrivilege)

The SQLRUserGroup also has "Allow log on localy"

we also added the "NT Service\MSSQLLaunchpad" to the administrator group with no luck.

this is our Sql Server version:

Microsoft SQL Server 2019 (RTM-CU19) (KB5023049) - 15.0.4298.1 (X64) Jan 27 2023 16:44:09 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Datacenter 10.0 <X64> (Build 20348: ) (Hypervisor)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,080 questions
{count} votes

Accepted answer
  1. Erland Sommarskog 103.5K Reputation points MVP
    2023-05-04T21:49:47.6033333+00:00

    I don't know much about this, but error 0x80070002 is the good ol' The system cannot find the file specified.

    Possibly you could use Process Monitor to figure out what file it is looking for but cannot find.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful