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 ...
Get Building Web Applications with Microsoft® Office SharePoint® Designer 2007 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.
