Network Libraries, TCP/IP Ports and Configuring SQL Server for Remote Connections - Video Series Video Category: Configuration: Services, Instances, Network Libraries, and More Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 Want to change your SQL Server's TCP/IP port? Then watch this series! This series takes an interesting look at how clients connect to SQL Server 2005 using Network Libraries. You'll learn how to manage the connections, change SQL Server's TCP port(s), how the SQL Browser Service works, and much more.

Videos in this Series:

Title Skill Length Download Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP an...   200 9 mins. Download Part 2 - SQL Server Network Library Discussion - TCP IP Connections and TCP IP P...   200 13 mins. Download Part 3 - Understanding the SQL Server Configuration Manager's Display of TCP IP ...   300 17 mins. Download Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configurati...   400 12 mins. Download Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports   500 8 mins. Download Part 6 - Using Aliases with TCP IP Connections   200 8 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

SQL Server 2000 Service Pack 3 Additions/Changes: New database role and server configuration to allow cross-database ownership chaining Helpful Tools for your SQL Server: Lumigent's Log Explorer is a great tool that allows you to read the transaction log and even undo transactions - very helpful in a crunch Helpful Keyboard Shortcuts: "Windows key" + "L" locks your computer