Article ID: 176378 - View products that this article applies to.
This article was previously published under Q176378
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to set up Microsoft SQL Server using Integrated Security on the same physical machine as Microsoft Internet Information Server.
When using SQL Server through a Trusted Connection, it may be necessary to host SQL Server and Internet Information Server on the same machine. This is commonly done with IIS 3.0 to work around limitations in accessing SQL Server through a Trusted Connection.
To allow access to SQL Server through a Trusted Connection, the SQL Server Login Security Mode needs to be set to either Mixed, or Windows NT Integrated. This can be changed from the Microsoft SQL Server Enterprise Manager,. From the Server menu, select SQL Server and Configure. The login settings are on the tab labeled Security Options.
To properly facilitate ActiveX Data Objects (ADO) connections from Active Server Pages (ASP), a System data source name (DSN) must be used.
Use the following steps to set up this DSN
After setting up this DSN, you may access it as you would normally in ASP code.
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:
(c) Microsoft Corporation 1997, All Rights Reserved. Contributions by
Paul Enfield, Microsoft Corporation
Article ID: 176378 - Last Review: February 28, 2014 - Revision: 5.1