HOWTO: Connect to the Microsoft SQL Server via Named Pipes

• Microsoft Internet Server Application Programming Interface (API)
• Active Server Pages
• Microsoft Internet Information Server versions 1.0, 2.0, 3.0, 4.0
• Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0

SUMMARY

When you connect to Microsoft SQL Server from the Active Server Pages (ASP) ADO 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.

MORE INFORMATION

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 will be in the form of IUSR_MachineName where MachineName is the name of the server hosting IIS.

This account must be verified by the server hosting 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.

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 more information about this behavior refer to the following articles in the Microsoft Knowledge Base:

Q152828 IIS Queries to SQL Server Generate Error 1326

Q142868 Authentication and Security Features

http://support.microsoft.com/support/vinterdev/

Additional query words: kbDSupport kbdsi

Keywords          : kbnetwork kbsetup kbASP kbNTOS400 kbScript kbSQLServ kbGrpASP 
Version           : winnt:1.0,2.0,3.0,4.0,4.2x,6.0,6.5,7.0
Platform          : winnt 
Issue type        : kbhowto 

Last Reviewed: May 27, 1999