Full error message when trying to connect to the database from the Orchestrate logon form:
Some system error has been encountered. The signin process has failed. the detailed information is as follows:
A network-related or instance-specific error occurred while establishing a connection to the SQL server. The server was not found or was not accessible. Verify 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 the SQL server)
This a local environment issue. Please ask your IT department to check the following:-
Is the firewall or antivirus software blocking access to the SQL server due to a update?
Check that allow remote connections for this server is enabled.
Check that TCP/IP and Named Pipes are enabled
Check the TCP/IP and Named Pipes protocols and port. Open SQL Server Configuration Manager and check the SQL Server Network Configuration protocols. You should enable Named Pipes and TCP/IP protocol.
An instance of the SQL Server Database Engine is not running.
The SQL Server Browser service is not running.
The TCP/IP is disabled.
The server name was typed incorrectly.
There are network problems.
The TCP/IP port for the Database Engine instance is blocked by a firewall.
The client and server are not configured to use the same network protocol
Your IT colleagues may have to to use the server IP address instead of alias.
Check the Orchestrate database permissions have been setup correctly for all relevant users.
If you are using a site to site VPN, within our Access hosted server environment, the remote IP address needs updating by our networks team, please raise a new case online and reference the title of this article.