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?
“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:
Check SQL Server is running
Make sure that Allow Remote Connections is enabled on sql server properties
Check if TCP/IP is enabled
Configure to allow SQL Server in Firewall Settings
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.
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.