Hi,
We have configured 2 job servers local and remote. Local job server connects to DB directly whereas Remote job server connects to DB via App server. We have added "SQL processing Server" function to Remote job server and it is able to process sql processes but we are getting below error in job service logs of remote job server.
\REMOTEJOBSERVER1 - VI.JobService.JobComponents.SQLComponent - F7E59028-E716-4CB0-B972-34FBFB7AA141: Errors occurred
[810143] Database error 53: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
[System.Data.SqlClient.SqlException] A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
[System.ComponentModel.Win32Exception] The network path was not found
We are not able to understand this issue as it is processing all the sql processes but throwing this error as well. Please suggest the right way to handle this. Thank you.