Administrator launches 'Controller Configuration', and selects relevant database connection. Administrator clicks green 'tick' button to test the connection. An error appears.
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server .
Both of the following are true:
- (1) The SQL server is not using the default TCP port (1433)
- (2) The I.T. administrator has erroneously decided to use the IP address inside the "data source".
If both of the above are true, then this stops Controller from locating the correct TCP port.
Resolving The Problem
Modify the 'Data source' so that it uses the SQL server's name (not its IP address):
Modify the SQL server so that it runs on the default TCP port (1433):
15 June 2018