I have a SQL Server with both TCP\IP and Named Pipes protocols enabled and configured.
From the server itself I can connect to the database using either TCP or Named Pipes, by specifying the connection as
However from another server I can only connect using TCP\IP using servername\instancename. Adding the
np: prefix just causes a connection timeout failure.
Do I need to open any specific ports in order to use Named Pipes? This is a named instance running on a dynamic port. The dynamic port is opened in the firewall.
The reason I'm looking into this is because I'm experiencing intermittent issues with an ODBC connection - timeouts, connection dropouts etc. From what I've read these issues have in the past been resolved by enabling Named Pipes - which I've done, but then by default my connections are using TCP, and by force, I can't get it to connect from this server.