Smartconnector Service Stops 'A network-related or instance-specific error occurred while establishing a connection to SQL Server'

[petri_greenwave]

Good Day,

I need some assistance with a smartconnector service for one of pour clients that just stopped, looks like it could not connect/logon to the SQL instance which resides on a different server.

I have attached the smartconnector log (error is right at the bottom) as well as the windows events on the smartconnector server as well as the SQL server.

There were no power downs/restarts on the OS during this period and no network issues as we would have had many other issues as well, which we didn't.

[Mike_Bielby]

Petri,

Did you get an answer to your question/issue. Depending on how the Smart Connector was written, losing the SQL DB connection might cause your smart connector to stop. One way to fix this is to make sure that you configure a schedule for the Smart connector in the Smart Connector Portal to restart after a failure.

We are close to releasing a Smart Connector troubleshooting flowchart and a troubleshooting Chat Bot.