Solved

SQL Network protocol

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
truncate SQL 2008 database log file 3 34
Help in SQL Full Text Search 3 28
Grid querry results 41 52
backups - Strategies 1 13
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

707 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

18 Experts available now in Live!

Get 1:1 Help Now