Microsoft KB Archive/159976

= How To Connect to the Microsoft SQL Server Through the Use of Named Pipes =

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





IN THIS TASK
SUMMARY
 * Procedures

REFERENCES



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.

back to the top

