What is happening here - is it trying to open a database that doesn't exist?
Log Name: Application
Source: MSSQLSERVER
Date: 12/11/2022 15:36:00
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: NT SERVICE\MSSQLSERVER
Computer: server.domain.local
Description:
Login failed for user 'NT SERVICE\MSSQLSERVER'. Reason: Failed to open the explicitly specified database 'Session State Database'. [CLIENT: <local machine>]
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">18456</EventID>
<Level>0</Level>
<Task>4</Task>
<Keywords>0x90000000000000</Keywords>
<TimeCreated SystemTime="2022-11-12T15:36:00.678678600Z" />
<EventRecordID>2261457</EventRecordID>
<Channel>Application</Channel>
<Computer>server.domain.local</Computer>
<Security UserID="S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003" />
</System>
<EventData>
<Data>NT SERVICE\MSSQLSERVER</Data>
<Data> Reason: Failed to open the explicitly specified database 'Session State Database'.</Data>
<Data> [CLIENT: <local machine>]</Data>
<Binary>184800000E0000000C000000540043004800410049004B004F00560053004B0059000000070000006D00610073007400650072000000</Binary>
</EventData>
</Event>
