Network Management

Disable Named Pipes on the SQL client

This article provides steps on disabling Named Pipes (through Windows Registry) on the server where SQL Client is installed.

First published date

10/30/2018 4:32 PM

Last published date

7/3/2020 4:21 PM

Overview

By default SQL Server can be reached using SQL Client using a few different ways, commonly called protocols. There are three protocols in the scope of SQL Server divided into two categories:
  1. Local protocol - Shared Memory
  2. Remote protocol - Named Pipes and TCP (they can also be used locally)
In this article, you will see how to disable Named Pipes on the client-server.

Product section

Orion Platform

Cause

N/A

Resolution

In order to disable Named Pipes protocol on the SQL client, follow the steps below (example for the SQL Server 2008 Client - ver 10.0):

  1. Open Windows Registry.
  2. Navigate to the below key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI10.0
  3. Double click on ProtocolOrder the key.
  4. Remove line with np (Named Pipes).
  5. Click OK.
  6. Double click on ProtocolsSupported the key.
  7. Remove line with np (Named Pipes)
  8. Click OK.

 

Note:

  • The above steps refer to changing values in Windows Registry - be careful while applying these changes and always make a backup of the registry keys being modified.
  • For different versions of the SQL Client please check Microsoft SQL Server Versions List (© 2007–2020 SqlServerBuilds.blogspot.com, available at https://sqlserverbuilds.blogspot.com/, obtained on July 3, 2020)