Solved

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

Posted on 2011-02-15
2
765 Views
Last Modified: 2012-05-11
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
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
mattisflones earned 500 total points
ID: 34896098
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
 
LVL 85
ID: 34915513
Thanks. That article did explain the basics of the various technologies, and I'll look further to find details as needed.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question