Post reply

MSSqlServer 10.50.6000.34 Event-ID 18456 LoginError

  • 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

     

     

  • October 22, 2023 at 11:58 am

    #4312829

    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]

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

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