March 13, 2009 at 1:35 pm
Strange behavior:
[298] SQLServer Error: 4060, Cannot open database "TestDB" requested by the login. The login failed. [SQLSTATE 42000]
[298] SQLServer Error: 18456, Login failed for user 'DOMAIN\Administrator'. [SQLSTATE 28000]
The problem is: I deleted that TestDB a day ago. It does not exist anymore!
What am I missing?
Thanks
Brano
March 13, 2009 at 1:54 pm
Do you have any Jobs, Scheduled tasks or something running that connects to that DB?
-Roy
March 13, 2009 at 2:07 pm
Thank you, that solved issue. I overlooked that sharepoint installation created job CDW_SHAREPOINT for that database.
It is gone.
Regards,
Brano
March 13, 2009 at 2:10 pm
Glad I could help.. 🙂
-Roy
January 31, 2022 at 3:25 am
SQL Server Strange behavior:
I have been Getting the following error massages non stop after full backup fails. this massage gets generated for each databases in this Availability Group. The job runs every night, and it call SSIS package. Both the SSIS and Job seems okay and the tricky part is that job fails once in a while like once in 10 days or so.
[298] SQLServer Error: 4060, Cannot open database "testDB" requested by the login. The login failed. [SQLSTATE 42000]
[298] SQLServer Error: 18456, Login failed for user 'Test\test-user-sql'. [SQLSTATE 28000]
Did I miss something here?
Thank you
Razel.
January 31, 2022 at 10:00 am
You had better started a new forum post ! Whenever I see new answers to old Questions, I skip it
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply