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

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