O'Reilly logo

Building Web Applications with Microsoft® Office SharePoint® Designer 2007 Step by Step by John Jansen

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

Creating a SQL Data Source

Displaying SQL data presents a unique set of challenges, not just in SharePoint, but in server technologies in general. When the SQL server is not on the same physical machine with the Internet Information Services (IIS) you are using for your Web application, the Web page that is trying to display information from that SQL server will fail to authenticate. Briefly: the ASPX page "hops" to the IIS server and is authenticated there, but cannot then "hop" again to the SQL server to authenticate there.

Tip

To learn more about the "double-hop" problem, search online for double hop authentication. You will find a rich array of information on the subject.

To get around this problem, you can use one of three techniques. The first ...

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