Article ID: 159976
Article Last Modified on 6/30/2006
APPLIES TO
- Microsoft Internet Server Application Programming Interface 4.0
- Microsoft Active Server Pages 4.0
- Microsoft Internet Information Server 1.0
- Microsoft Internet Information Server 2.0
- Microsoft Internet Information Server 3.0
- Microsoft Internet Information Server 4.0
- Microsoft SQL Server 4.21a Standard Edition
- Microsoft SQL Server 6.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q159976
SUMMARY
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.
back to the top
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.
REFERENCES
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:
Keywords: kbhowto kbhowtomaster kbnetwork kbscript kbsetup KB159976
