The information in this article applies to:
SUMMARYMicrosoft SQL Server 6.5 can be used with Active Server Pages (ASP) and Internet Information Server 3.0 (IIS). When SQL Server is configured for Mixed or Integrated Security, certain configuration changes must be made to enable ASP to connect to SQL Server via a trusted connection. This article describes these changes and how to set up Internet Information Server to properly connect to SQL Server over a trusted connection. MORE INFORMATION
In order for ASP scripts to make a trusted connection to SQL Server using
ActiveX Data Objects (ADO), the users must be authenticated when they
browse the Web page making such a connection. If you force the users to
authenticate themselves via Basic authentication, IIS has all information
required to make the trusted connection to SQL Server. If any other
authentication method is used (NT Challenge/Response or Anonymous), IIS is
not be able to make this connection.
REFERENCES
For additional information, please see the following article(s) in the
Microsoft Knowledge Base:
Q176377 INFO: Accessing SQL Server with Integrated Security from ASP For the latest Knowledge Base artices and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site: http://support.microsoft.com/support/vinterdev/ (c) Microsoft Corporation 1997, All Rights Reserved. Contributions by Paul Enfield, Microsoft Corporation Additional query words:
Keywords : kbASP kbSecurity kbSQLServ kbWebServer kbGrpASP kbiis300 kbiis400 kbiis500 |
Last Reviewed: December 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |