Post reply

SQLServer Error: 4060, Cannot open database

  • March 13, 2009 at 1:35 pm

    #128634

    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

    #959425

    Do you have any Jobs, Scheduled tasks or something running that connects to that DB?

    -Roy

  • March 13, 2009 at 2:07 pm

    #959430

    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

    #959435

    Glad I could help.. 🙂

    -Roy

  • January 31, 2022 at 3:25 am

    #3978998

     

    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]

    • Server; SQL Server 2016 AG with 2 replica synchronized.
    • More than 10 databases configured in this AG
    • Backup preference; any replica

    Did I miss something here?

    Thank you

    Razel.

     

  • January 31, 2022 at 10:00 am

    #3979087

    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