Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 774
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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