Solved

SQL Network protocol

Posted on 2013-01-21
1
309 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
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

809 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