Article ID: 149425
Article Last Modified on 6/23/2005
APPLIES TO
- Microsoft Internet Information Server 1.0
This article was previously published under Q149425
We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:
SYMPTOMS
When you access an IDC script, you may receive the following error message:
CAUSE
The error message above may occur in the following conditions:
- Your SQL Server is not the same computer as your Internet Information Server (IIS).
- You are using Microsoft Windows NT Challenge/Response authentication on IIS.
- You are using Integrated or Mixed Security on the Microsoft SQL Server.
- You are not are not providing the Username: or Password: values in your IDC Script.
WORKAROUND
There are two possible workarounds:
- Install SQL Server on the same computer as the Internet Information Server and set up your ODBC System DSN to be Local Server instead or a remote computer name.
-or-
- Use Basic Authentication instead of Windows NT Challenge/Response (for example, the user will be prompted to login using a dialog box)
MORE INFORMATION
When the client executes the IDC script, IIS must determine whether the datasource is local or remote. If the datasource defined as Local System, the query is passed to the SQL Server on the same computer. If the datasource is remote, IIS must make a network connection to SQL Server. When it does, it does not pass the credentials of user logged on to the client computer; instead, it passes a blank username and password.
The SQL Server tries to validate a user without a username; it fails, and it returns the following message to IIS:
The Internet Information Server then passes the results of the query to the client web browser.
Additional query words: prodiis winnt
Keywords: kbnetwork KB149425