KB149425 - IDC: Error Performing Query, Not Defined as a Valid User

Article ID: 149425

Article Last Modified on 6/23/2005

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:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SYMPTOMS

When you access an IDC script, you may receive the following error message:

Error Performing Query
*[State=3700][Error=18450][Microsoft][ODBC SQL Driver][SQL Server]
Login failed- User: _ Reason: Not defined as a valid user of a
trusted SQL Server Connection.

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