Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

Named Pipes, TCPIP, Shared Memory, etc for SQL Server

Can someone please explain the differences regarding the various connection methods available for SQL Server (2005 and 2008 specifically)

I've seen the Wikipedia stuff, so please no links to content of that nature

I'm more interested in things like why I should choose one method over another, for exampe - or are there any drawbacks to enabling ALL of them, etc etc. What are the advantages/disadvantages of doing these things?



0
Scott McDaniel (Microsoft Access MVP - EE MVE )
Asked:
Scott McDaniel (Microsoft Access MVP - EE MVE )
1 Solution
 
mattisflonesCommented:
There are no advantages/disadvantages other than the obvious ones.. TCP/IP can be accessible to the public with all the security concerns that brings, can be impacted by LAN performance and so on.. Shared memory is for internal use, and so on.. Just different protocolls and surfaces.

And as with everything else, enable only what you will use.


I find this short article to be "all you need...", atleast for the basics of choosing.

http://msdn.microsoft.com/en-us/library/ms187892.aspx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareAuthor Commented:
Thanks. That article did explain the basics of the various technologies, and I'll look further to find details as needed.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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