Discussions specific to the VMware vSphere hypervisor
Post Reply
rurouni
Enthusiast
Posts: 68
Liked: 6 times
Joined: Jul 24, 2013 7:21 pm
Contact:

Error information: SQL server is not available

Post by 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.
Product Manager
Posts: 25361
Liked: 2238 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Error information: SQL server is not available

Post by 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
Enthusiast
Posts: 68
Liked: 6 times
Joined: Jul 24, 2013 7:21 pm
Contact:

Re: Error information: SQL server is not available

Post by 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.
Product Manager
Posts: 25361
Liked: 2238 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Error information: SQL server is not available

Post by Vitaliy S. »


rurouni
Enthusiast
Posts: 68
Liked: 6 times
Joined: Jul 24, 2013 7:21 pm
Contact:

Re: Error information: SQL server is not available

Post by rurouni » 1 person likes this post

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

Post Reply

Who is online

Users browsing this forum: SerSunal and 54 guests