Error information: SQL server is not available

[rurouni]

Hi,

For Quite some time now we're observing this behaviour on some of our jobs. Backups fail with this error:

"Error: Microsoft SQL server hosting the configuration database is currently unavailable. Possible reasons are heavy load, networking issue, server reboot, or hot backup. Please wait, and try again later. Error information: SQL server is not available"

At the same time some other jobs are running and database is available.
On retry, those jobs usually succeed.

While inverstigating the Job logs, i found this:

"<01> Error Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (System.Data.SqlClient.SqlException)"
"<01> Error SQL server is not available (Veeam.Backup.Common.CAppException)"
"<01> Error Microsoft SQL server hosting the configuration database is currently unavailable. Possible reasons are heavy load, networking issue, server reboot, or hot backup."

At this moment on SQL Server Instance we find these logs:

"SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed."
"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

Surprisingly, This SQL Server hosts multiple instances and Veeam BAckup instance is the only one reporting these logon failure.

Any Idea about It?

Thank you.

Case #00818574.

[Vitaliy S.]

I see that our support team has offered you to switch to a SQL authentication method to narrow down the scope of the issue . Did it help?

[rurouni]

That's what were were thinking about.
Is there a procedure somewhere which describes how to switch to SQL Authentication Method?
I'll ask support Team by the way.
Thank you.

[Vitaliy S.]

Yes, there is > Specify Connection Settings

[rurouni]

We changed to sql authentication and now it Works better without sql server issues.
Thanks.