MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError

Question

MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError

UserX

SSC Enthusiast

Points: 114
More actions
October 22, 2023 at 11:52 am

#4312827
Dear Experts,
Nothing special, just an annoying returning entry in Windows-Event- Protocol.
=> SQL Server 2008
However, the Event viewer is throwing permanently an error:
Error logging in for the user 'NT-AUTHORITY\SYSTEM'. Cause: Error opening the explicitly specified database. [CLIENT: <local machine>]
```
- System 

  - Provider 

   [ Name]  MSSQLSERVER 
 
  - EventID 18456 

   [ Qualifiers]  49152 
 
   Level 0 
 
   Task 4 
 
   Keywords 0x90000000000000 
 
  - TimeCreated 

   [ SystemTime]  2023-10-22T11:35:02.000000000Z 
 
   EventRecordID 7945109 
 
   Channel Application 
 
   Computer Some.Server.ID
 
  - Security 

   [ UserID]  S-1-5-18 
 
```
Anyone can help us ?
Is there a workaround to fix it ?
Thank you, in advance.
Stephan
September 20, 2024 at 8:30 pm

This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 1

So there is a service or a job on your machine that tries to connect to your SQL Server instance, but which is set up to connect to a non-existing database. You need to find that service/job and delete/reconfigure it.

Job here could be an Agent job, but also something running from Task Scheduler.

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]