We are using Sage 2022 that uses SQL Server 2012 as its database (fully patched with latest updates). Intermittingly it loses connection to the database and there appears to be on the surface no reason for this.

We have checked out the usual culprits. The SQL service in each instance is running. We are using a static IP address and there are no issues as it pertains to the firewall(s).

When reviewed the SQL logs we get error messages like the ones below:

"Error: 18456, Severity: 14, State: 38. Login failed for user 'NT SERVICE\ReportServer'. Reason: Failed to open the explicitly specified database 'ReportServer'. [CLIENT: fe80::e504:e492:944e:d309%16]"

"The Service Broker endpoint is in disabled or stopped state. The Database Mirroring endpoint is in disabled or stopped state."

"I/O is frozen on database model. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup."

We are making the assumption the above messages are directly related to our issue but not being SQL experts were curious as to what these actually mean.

Is this a database backup issue? Where for whatever reason the backup is taking longer than expected and breaking our connection?

If this is the case what are some changes we could make to prevent this from happening again?

Thanks in advance for any postings or suggestions.