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

config manager- Named pipes disabled

1)in the below screenshot, is the
SQL Server Network Config &
SQL Native Client 10.0 configuration
referring to 64 bits?

2)SQL Server Network Config->Protocols for MSSQLSERVER has Named Pipes disabled- does it have potential to cause trouble or is this not important?
0
25112
Asked:
25112
  • 2
  • 2
3 Solutions
 
25112Author Commented:
attached
pipes.jpg
0
 
JestersGrindCommented:
Named pipes is just another method for clients to communicate with SQL Server.  If all of your clients are connecting via TCP/IP(which I imagine that they are), there is no need for named pipes.

Greg

0
 
lcohanDatabase AnalystCommented:
if you use TCPIP exclusively it doesn't realy matter however as client protocol named pipes are enabled you may want to enable it at server level as well:

Choosing a Network Protocol
http://msdn.microsoft.com/en-us/library/ms187892.aspx
0
 
JestersGrindCommented:
By the way, here is an article discussing named pipes vs TCP/IP.  It's SQL 2000, but I believe it still applies.

http://msdn.microsoft.com/en-us/library/aa178138%28SQL.80%29.aspx

Greg

0
 
25112Author Commented:
good to know..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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