Solved

SQL Network protocol

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now