Data Sources suddenly starting to fail

Hi Nick_D ,

You can first reconfigure the SQL Server data source in Manage Gateway as suggested by GilbertQ  and check if similar problems still exist after restarting the gateway.

I can see here that the information you provided is a SQL Server connection issue, it would be nice to have more detailed information on the error message.

To effectively use this troubleshooter, you may want to gather the following information.

1.The complete text of the error message along with the error codes and whether the error is intermittent (happens only sometimes) or consistent (happens all the time).

2.Errorlogs from SQL Server from which you can note the following:

A. Fully qualified domain name (FQDN) of the SQL Server machine or in case of clustered installations, the FQDN virtual name. If you are using a named instance, note down the instance name.

B.Network libraries and ports the SQL instance is listening on. 

3.Application and System event logs from SQL Server and Client systems.

4.If the connections are failing from an application, the connection string from the app. These are typically found in Web.config files for ASP.NET applications.

For more information，you can refer to：Resolving connectivity errors to SQL Server 

If I have not understood your needs correctly, please do not hesitate to inform me.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.