Configure named pipes on SQL 2008 R2 Cluster

Question

Hello,

is there a possibility to configure named pipes on a SQL 2008 R2 Cluster??

If yes i would be very,very thankful for a detailed advice!:)

Thx,

Rene

Answer 1

Hi Falken,

Yes it is possible to configure Named Pipes on SQL 2008 R2 Cluster. How please check below link under heading:

Problem: The Network Name is offline and you cannot connect to SQL Server using TCP/IP.

http://msdn.microsoft.com/en-us/library/ms189117.aspx

Now my main question is why we want to enable Name Pipe? Is that we are facing some issues with TCP/IP?

Below is a link to SQLSERVERCENTRAL discussion "What is advantahe of using Named Pipes over TCP?

http://www.sqlservercentral.com/Forums/Topic488216-146-1.aspx 

---

Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++

Answer 2

Hi,

Below is another link which talks about difference between Named Pipes VS Tcp/Ip.

http://msdn.microsoft.com/en-us/library/aa178138(SQL.80).aspx

 

---

Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++