Client/Server Networking Considerations

Before we delve into the features on the client side in SQL Server, it’s important to make note of a few server-side features. This information will help you gain an understanding of which networking features are initially configured on the server (after an installation or upgrade) as well as how incoming connections are dealt with. Such knowledge can be invaluable in diagnosing connectivity issues.

If you’ve been following along chapter by chapter, you’ve learned how to install or upgrade an instance of SQL Server 2014. To get your clients up and running fast, you must be sure the Database Engine is listening for them.

The following sections describe how to set up the server’s basic network configuration, ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.