Post reply

Named Pipe As well As TCPIP

  • November 13, 2009 at 4:34 am

    #385783

    We have a ASP Classic application that uses DSN. DSN is configured to use TCPIP to connect SQL Server.

    Our SQL Server is configured to use Named Pipe as well as TCPIP.

    Few days before there was some issue with the TCPIP. Because of that the whole ASP Classic application was DOWN.

    So my question is Can we setup DSN to use both the protocols Named Pipe and TCPIP? First it should use TCPIP, if TCPIP is not available then it should use Named Pipe.

    If DSN can't be configured to use both, is it possible to write a connection string (see below) that can make use of Named Pipe if TCPIP is not available ? Always the first preference should be TCPIP

    Application("con") = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=pubs;User ID=sa "

    I have one more question. Is the above connection will make use of the TCPIP and Named Pipe both based on the priority ?

    Thanks,

  • November 13, 2009 at 8:02 am

    #1078943

    So the SQL Server is local to the web server? If so then NONE of those protocols would/should be used, it should be using shared memory.

    How you reference the server and the order of the protocols is defined more or less globally for a machine. In SQL 2005 the SQL Server Configuration Manager is used to handle that. After you open that near the bottom on the left side is SQL Native Client Configuration, expand that and you will see Client Protocols, click on that. You probably have 3 enabled Shared Memory, TCP/IP, and Named Pipes, in that order. That is the order that they will be tried. Shared memory will only be used for local machines.

    I think the problem could come down to how you refer to the remote server (if that is what you are doing). If you refer to it by the name "SQLServer01" you probably won't have any problems. But if it is "SQLServer01.mydomain.com" then I think you will have a problem..

    Also, if in the SQL Server Client Configuration tool there is an alias for that server, then the protocol specified in the alias will ALWAYS be used..

    CEWII

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply