Solved

config manager- Named pipes disabled

Posted on 2011-09-09
5
366 Views
Last Modified: 2012-05-12
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
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 5

Author Comment

by:25112
ID: 36511860
attached
pipes.jpg
0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 334 total points
ID: 36512182
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
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 166 total points
ID: 36512199
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
 
LVL 21

Assisted Solution

by:JestersGrind
JestersGrind earned 334 total points
ID: 36512201
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
 
LVL 5

Author Comment

by:25112
ID: 36517457
good to know..
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question