question

Mohan avatar image
Mohan asked

Named Pipes Importance

what is named pipes and its importance?

sql-server-2005
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
sp_lock avatar image
sp_lock answered

The answer can be found on Stack.

http://stackoverflow.com/questions/175579/what-are-named-pipes

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

venkatreddy avatar image
venkatreddy answered

Named pipes are protocols in SQL server.If you choose named pipes as your protocols for your server then it will allows local connections and remote connections in the same network.It gives poor performance and security.No inbuilt security provided.

We have 4 protocols in SQL Server 1)Shared memory 2)named pipes 3)TCP/IP 4)VIA

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

CirqueDeSQLeil avatar image CirqueDeSQLeil commented ·
+1 agreed. I don't prefer this protocol and often disable it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.