Solved

SQL Network protocol

Posted on 2013-01-21
1
316 Views
Last Modified: 2013-01-30
Hi,
anyone have any idea about shared memory , namepipe protocol ? Our server have this two protocol enable.. I'm not sure if our sql require this protocol or not. but when I check in sys.dm_exec_connections, there seems some connection using both protocol.

I also connect to other sql server remotely, but it seems sql is connected me using namepipe. Below are the result from the registered server in ssms

SELECT net_transport
FROM sys.dm_exec_connections
WHERE session_id = @@SPID;


Server Name      net_transport
Server-A      Shared memory
Server-B      Named pipe
Server-C      Named pipe
Server-D      Named pipe
0
Comment
Question by:motioneye
[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
1 Comment
 
LVL 12

Accepted Solution

by:
NormanMaina earned 500 total points
ID: 38804351
Server A: Since its using shared memory , you cannot connect to it using applications or remotely using sql server management in any other computer over the network.

Other Servers:Remote access possible

The protocols that client applications can connect to Microsoft SQL Server are:
1.TCP/IP:
TCP/IP is a common protocol widely used over the Internet. It communicates across interconnected networks of computers that have diverse hardware architectures and various operating systems. TCP/IP includes standards for routing network traffic and offers advanced security features. It is the most popular protocol that is used in business today.
2.named pipes:
It is a protocol developed for local area networks. A part of memory is used by one process to pass information to another process, so that the output of one is the input of the other. The second process can be local (on the same computer as the first) or remote (on a networked computer).
3VIA
Virtual Interface Adapter (VIA) protocol works with VIA hardware..
4. shared memory protocols.
Shared memory is the simplest protocol to use and has no configurable settings. Because clients using the shared memory protocol can only connect to a SQL Server instance running on the same computer, it is not useful for most database activity.

Coutesy:
http://msdn.microsoft.com/en-us/library/ms187892%28v=sql.105%29.aspx
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

Suggested Solutions

Title # Comments Views Activity
Query Syntax 17 52
PolyServe for SQL server 13 43
T-SQL: I need to add an index on a field 5 27
MSSQL 2008 R2  Check to see if a Index/Key Exist 7 9
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

733 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