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:

Security Tip: Protect your backups! Many DBAs often do not realize that anyone that can get to your SQL Server database backups can also restore those backups on their own SQL Server. One additional layer of file-based security that you can add in is to put a password on your backup file. This can only be done with Transact-SQL but it cannot be bypassed during the restore Helpful Keyboard Shortcuts: "Windows key" + "R" quickly launches the command line "Run" prompt Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed.