O'Reilly logo

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step by Solid Quality Learning

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

Access to SQL Server through an Extra Layer

So far in this chapter, we have investigated how to expose SQL Server directly to client applications on external networks.

Because SQL Server maintains valuable data, it’s generally not a good idea to expose your installation to broad networks, such as the Internet, because of security issues. Additionally, exposing SQL Server directly to external networks limits scalability and performance and complicates server administration.

The benefits of implementing a middle tier between the client application and SQL Server are as follows:

  • A middle tier provides an extra layer of security that filters all incoming requests.

  • You can use components of the operating system infrastructure, such as Internet Information ...

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