When you connect to Microsoft SQL Server from the Active Server Pages (ASP) using ActiveX Data Objects via named pipes, the client computer must be validated by SQL Server to use the named pipe. If SQL Server is on a different physical computer than the ASP files, the Active Server Pages might fail.
By default, Internet Information Server (IIS) attempts to connect to the
SQL Server anonymously. To do this, it uses the anonymous logon information
provided in Internet Service Manager (Inetmgr.exe). Typically, this is
in the form of IUSR_
MachineName where
MachineName is the name of the server that hosts IIS.
This account must be verified by the server that hosts Microsoft SQL Server in order for the connection to occur properly. If this account is not
verified, then the connection fails and provides only the line number in
the script file of the attempted connection opening.
Procedures
To resolve this problem, you can use one of the following options:
- Enable the Windows NT ID guest.
- Make the Windows NT user, IUSR_MachineName, a member of the domain where SQL Server resides.
- Use the account information from Internet Service Manager to set up a
local user account on the Windows NT Server that hosts SQL Server.
For the latest Knowledge Base articles and other support information on
Microsoft Visual InterDev and Active Server Pages, see the following Microsoft Product Support Services Web page: