What is the name of the protocol that the SQL Server browser uses to communicate?
Choose your answer:
A:SQL Server Browser Protocol (SSBP)
B:SQL Server Resolution Protocol (SSRP)
C:Tabular Data Stream (TDS)
D:Transmission Data Service (TDS)
正确答案和中文解释见后文
Correct answer: B
SQL Server Resolution Protocol (SSRP)
The protocol used by the SQL Server Browser service is the SQL Server Resolution Protocol (SSRP).
Prior to SQL Server 2000, only one instance of SQL Server could be installed on a computer. SQL Server listened for incoming requests on port 1433, assigned to SQL Server by the official Internet Assigned Numbers Authority (IANA). Only one instance of SQL Server can use a port, so when SQL Server 2000 introduced support for multiple instances of SQL Server, SQL Server Resolution Protocol (SSRP) was developed to listen on UDP port 1434. This listener service responded to client requests with the names of the installed instances, and the ports or named pipes used by the instance
Ref：https://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx
在 SQL Server 2000 之前，一台计算机上只能安装一个 SQL Server 实例。 SQL Server 侦听 1433 端口上的传入请求，该端口由官方的 Internet 号码分配机构 (IANA) 分配给 SQL Server。 只有 SQL Server 的一个实例可以使用端口，因此，在 SQL Server 2000 引入了对多个 SQL Server 实例的支持时，SQL Server 解析协议 (SSRP) 是为侦听 UDP 端口 1434 而开发的。 此侦听器服务使用已安装实例的名称以及该实例使用的端口或命名管道响应客户端请求。
