Conclusion

This chapter focused on how to access SQL Server data from remote client applications, either by exposing SQL Server directly to the Internet or by writing a middle-tier service interface. Using a direct connection through the Internet provides a great deal of flexibility, but also exposes your installation to security risks. Using a middle-tier architecture provides a secure interface for your SQL Server, enhances scalability and performance, and eases configuration and maintenance tasks.

Chapter 9 Quick Reference

ToDo this
Open a connection to SQL Server through TCP/IP

  1. Enable the TCP/IP communication protocol.

  2. Configure a SQL Server instance to listen on a specific IP address.

  3. Provide client applications with the exact IP address and ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step 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.

Start your free trial