Solved

SQL Network protocol

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

630 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