Post reply

Local pipe vs Network pipe

  • April 1, 2003 at 5:20 pm

    #101424

    How do configure SS2K to listen to only a local pipe and disallow connection to it via a network pipe?

    Is disable network named piped for a SS2K as simple as removing 'named pipe' server protocol using the SQL Server network utility?

    And, is it impossible to disable local named pipe connections?

    Thanks in advance,

    Billy

    Edited by - bp on 04/01/2003 5:24:27 PM

  • April 1, 2003 at 11:55 pm

    #452791

    Yes, if you remove named pipes from the server netwrok protocols listened on then it is not possible to connect to it using named pipes. Not sure about local named pipes, however I don't think they'll be used as a local connection normally use shared memory to connect to server, and I don't think you can remove that.

    --

    Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

    http://www.sql.nu

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • April 2, 2003 at 7:27 am

    #452821

    Are you running MSDE 2000 or SQL Server 2000?

    After configure an instance of SQL Server not to listen for any network protocols, all applications on the same computer communicate with the instance by using the shared memory Net-Library.

    Use Server Network utility to configure an existing instance of SQL Server 2000 or MSDE 2000 not to listen for any network connections.

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

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