Skip to main content
InSource KnowledgeCenter

028395 - An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider,

Problem

After taking the Active Factory node off the network, all attempts to connect to the remote Historian node with Active Factory failed with a popup warning, "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

Product Version: 9.2

OS: Win 2003

OS_SP: R2 SP2

Solution

Checked the Server Properties within SQL Server Management Studio on the SQL Server node and found that Allow Remote Connections to this server was checked. All alias were removed from Client Configuration in the SQL Server Configuration Manager, and verified that both Named Pipes and TCP were enabled. Checking the client side we found that a UDL test connection against the Historian was successful. We ran cliconfig on the Active Factory client, and ensured that the alias were correct, and that Named Pipes and TCP were enabled. We next opened Active Factory and tested a connection using an IP address. The connection succeeded, but attempts using the server name continued to fail. Had customer delete the connection from within AF Trend > Tools > Servers, apply the change. Shut down Active Factory Trend, restart and recreate the connection. From that point forward, all connection attempts using the server name succeeded. OK to close.

Close Date: 2009-07-16 11:18:06