How To Connect to the Microsoft SQL Server via Named Pipes

The information in this article applies to:

• Microsoft Active Server Pages, version 1.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 do one of the following:

1. Use the account information from Internet Service Manager to set up a local user account on the Windows NT Server that hosts SQL Server.

2. Make the Windows NT ID IUSR_MachineName a member of the domain where SQL server resides.

3. Enable the Windows NT ID Guest.

REFERENCES

For more information about this behavior refer to the following articles in the Microsoft Knowledge Base:

   Article-ID: Q152828
   TITLE     : IIS Queries to SQL Server Generate Error 1326

   Article-ID: Q142868
   TITLE     : Authentication and Security Features

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

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