Speaking to Sql Server, between Shared Memory, Named pipe and TCP/IP protocols
Hi Friends, I hope you have had an Happy Easter! Have you ever wondered how your application or the SSMS itself talks to the database engine? Let's start today by talking about some basic concepts: Protocols GO! Speaking to the database engine. You know already, from the previous posts, that SQL Server engine is a service . The database engine is a service The question of today as sayd is: how do the applications speak to this service? How does he respond? Well, to talk to SQL Server there are three protocols that you can view by starting Sql Server Configuration Manager . These three protocols are named: Shared Memory Named Pipe TCP/IP Basically: With the Shared Memory protocol , the simplest protocol, you can only use it in a local connection . In this case the application and the SQL Server need to run on the same machine. The Named Pipe is used to connect inside a local area network (LAN) With the TCP/IP protocol (the most used) you can have a remote or clien...