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
- On the machine running Windows NT 4.0 that hosts these two products,
click the Start menu.
- Select Settings.
- Click Control Panel.
- Double-click ODBC.
- Select the System DSN tab from the tabbed dialog box.
- Click Add.
- Select the SQL Server ODBC driver from the list.
- Name your new data source.
- In the Server combo-box, type "(local)" without the quotes.
- Check the "Trusted Connection" check box.
- Change whatever additional settings are necessary for your DSN.
- Click OK.
By setting the server to (local) we are preventing anyone using this DSN
from looking out to the network for the SQL Server. By avoiding this step,
you prevent the NTLM authentication process necessary to establish a
trusted connection to SQL Server.
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