• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 876
  • Last Modified:

surface area config tool move tcp before named pipes

Using SQL Server Configuration Manager on the client computer, move TCP before named pipes in the protocol order list.
i saw this suggestion for a connection problem, but how to move tcp before named pipes in protocol order list?
1 Solution
DBAduck - Ben MillerPrincipal ConsultantCommented:
Depending on your Operating system, you can go into Network Connections in Control Panel (Win2k3) and click on Advanced menu and choose Advanced Settings.  You will then see a Provider Order Tab and that will let you move on or the other up.

This is for the Operating System order.
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> move TCP before named pipes in the protocol order list.

1. Open SQL Server Configuration Manager:
2. Expand SQL Native Client Configuation -> Client Protocols
3. Right Click TCP/IP and specify some order such that it is lesser than Named pipes to move it up.

Hope this helps.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now