SQLServer Error: 4060, Cannot open database in Availability Group

• Razel

  SSC Enthusiast

  Points: 180

  More actions

  January 31, 2022 at 2:39 pm

  #3979181

  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.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  February 1, 2022 at 3:10 pm

  #3979625

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.