3246392 - SAP instance startup failure due to "Login failed" while R3trans -d works without issue - NetWeaver

• SAP instance can not be started and dev_w<n> trace shows:
  
  

  C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3247]
  C  (18456) [28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user '<username but not SAPService<SID>>'.

  or
  
  C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2981]
  C  (18452) [28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
  
  
• ERRORLOG shows
  
  Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: xxx.xxx.xxx.xxx]
  Logon,Unknown,Error: 18452<c/> Severity: 14<c/> State: 1.
  Logon,Unknown,SSPI handshake failed with error code 0x8009030c<c/> state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: xxx.xxx.xxx.xxx]
  Logon,Unknown,Error: 17806<c/> Severity: 20<c/> State: 14.
  
  
• R3trans -d command finishes successfully.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

18452, 28000, Login failed, Login failed for user, SAPSerivce<SID> , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem