The three most common types of SQL server network configuration are local, remote, and site-wide. In a local configuration, the processes are segregated into separate processes. A remote connection is one in which multiple users connect to the server. A site-wide application is the most flexible and the most efficient for applications requiring seamless connectivity with many users, and it is used for e-commerce applications, web content management, internal server processes, and any other application that require secure communication between various modules.
Before setting up the SQL server network configuration, it is necessary to define the required protocols. The most important ones are TCP/IP, ICQ, Java Management Interface, and XML. The client applications use these protocols to communicate with the server instance. Some of these protocols, like TCP/IP and Java Management Interface are implemented in the operating system and they make the communications much easier and secure.