When running Configuration Wizard you have following Error.
This error indicates that your physical server is not able to connect to SQL Server at all for some reason .
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)
(Please consult your DBA before making any changes )
This is most common Error where your SQL Server is rejecting connection form Outside for some reason.
You might have incorrect Credentials to access the SQL server therefore the Configuration wizard is failing to connect to the DB Server.
Make sure the SQL Server and SQL Server Browser services are running at all times on the server hosting your SQL instance.
Further more please go through with following post in details further to isolate the issue .
You can also check the host file if you have ever changed it as well as your dns configuration
Install SQL Studio Management Console on Orion Server .
Once Done follow the post below. Make sure you are able to connect to SQL Server using SQL Studio .
In some cases its simply turning off the Windows Firewall on SQL Server also worth checking the FW on Orion Server as well.
You can also use the below 3rd party DB connectivity tools to check if you are able to reach out to SQL server.
3RD PARTY DB CONNECTIVITY TEST UTILITY
If you want to quickly test a database connection this is it.
You can also use this to quickly execute sql command and see the output in a grid.
Provides exception information to help troubleshoot connection issues. for more details please find the link below.
Database Connection String / Command / SQL Tester Utililty Download Link
QUICK DATABASE CONNECTIVITY TESTING