Fail to execute jobs on Render Farm, what's wrong?

We are trying to launch a job from UE4.25 using the render farm composed of 8 nodes, but every time we launch a job it fails giving several errors including:

17:05:38: [PostJobStatsToDB] Database error:
17:05:38: [PostJobStatsToDB] 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)

Also I see that despite there are 8 nodes only some work and the others don’t.

Firewall rules are set up correctly

File and Printer Sharing (Echo Request - ICMPv4-In) → Allow
File and Printer Sharing (Echo Request - ICMPv6-In) → Allow

File and Printer Sharing (Echo Request - ICMPv4-out) → Allow
File and Printer Sharing (Echo Request - ICMPv6-out) → Allow

for private and domain networks.

Could you give me some indication on how to make render farm work in the correct way?

Thanks,
Claudio

Hello,

“Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)” appears mostly when SQL Server does not allow remote connections, Firewall Settings or TCP/IP is not enabled.

You can try to troubleshhot fast:

  1. Check SQL Server is running
  2. Make sure that Allow Remote Connections is enabled on sql server properties
  3. Check if TCP/IP is enabled
  4. Configure to allow SQL Server in Firewall Settings
  5. Check for working fine SQL Server Browser
  6. Make sure that you can ping the SQL Server

Ore you can go step by step expained on the following article: https://www.get-itsolutions.com/sql-server-error-26-sql-error-40-fix/

Thnx

Hi Fantazma0,
thanks for reply. What i’m asking to my-self is why i need to setup SQL Server in order to use the render farm? Into the documentation there isn’t a part who talk about SQL a requirement.

Thanks,
Claudio

Hi Fantazma0,
thanks for reply. What i’m asking to my-self is why i need to setup SQL Server in order to use the render farm? Into the documentation there isn’t a part who talk about SQL a requirement.

Thanks,
Claudio