O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Role of SQL Browser

You might be surprised to learn that when clients try to connect to SQL Server 2012, their first network access is made over UDP Port 1434 to the SQL Browser service.

Note

Regardless of the encryption status of the connection itself, login credentials are always encrypted when passed to SQL Server 2012 (to foil any malicious packet sniffing). If a certificate signed by an external authority (such as VeriSign) is not installed on the server, SQL Server automatically generates a self-signed certificate for use in encrypting login credentials.

SQL Browser is the upgrade to the old SQL Server Resolution Protocol (SSRP), and its job is to hand out instance names, version numbers, and connection information for each (nonhidden) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required