April 21, 2008 at 1:57 pm
I used cluster for DB and named pipes 135 and 445 for connection. Someone said it was more secure using named pipes over TCP.
Is that true?
April 21, 2008 at 9:45 pm
Not sure that's true. I'd be curious if there were proof somewhere.
Named pipes is an older technology, super-seeded by TCP Sockets. Not sure it's better or worse, mostly think the SQL team doesn't wanted to support more protocols.
April 22, 2008 at 12:09 am
When we are using Enterprise Manager than by default it's using named pipes. Tcp ip is generally used to connect the application to database as it's Technologically advanced and more secure. Don't know how. 😛
Also I was facing some problem when I restore large database through EM it was hanging the system but works fine while create the job for the same. As job execution is using tcpip.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2008 at 5:51 am
Named pipes is indeed an older technology and are faster because no encryption is used... Hence it is less secure than the use of TCP/IP
Also the use of named pipes is limited to the local subnet.
So I recommend the use of named pipes only locally on the server for administering, other connections should use TCP/IP.
Regards
Zekske
April 22, 2008 at 9:27 am
I just want to clarify we only use named pipes wen we set up DB clusters.
April 22, 2008 at 2:23 pm
Here is an article comparing Named Pipes and TCP/IP
http://msdn2.microsoft.com/en-us/library/aa178138(SQL.80).aspx
May it help.
April 22, 2008 at 4:47 pm
Steve Jones - Editor (4/21/2008)
Named pipes is an older technology, super-seeded by TCP Sockets.
Not disputing anything else posted here, but Named Pipes are nowhere near as old as TCP/IP sockets which date back to 1983 and are thus older than many of the participants in this forum.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 23, 2008 at 2:55 am
A named pipe connection requires far more traffic to transmit data than does TCP.
If you are running clients on a local LAN, in practice you will find very little diffrence in performance. If your clients are connecting over a WAN, you will notice a performance difference, with TCP being much faster.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 23, 2008 at 7:10 am
My company is doing e-business, speed definitely is a big concern. Also all the employees are working at home dial in using VPN.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply