October 22, 2023 at 11:52 am
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
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]
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy