DOCUMENT:Q149425  02-MAY-1999  [iis]
TITLE   :IDC: Error Performing Query, Not Defined as a Valid User
PRODUCT :Internet Information Server
PROD/VER:1.0 3.51
OPER/SYS:
KEYWORDS:kbnetwork

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Internet Information Server 1.0 
-------------------------------------------------------------------------------

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:

   Login failed- User: _ Reason: Not defined as a
   valid user of a trusted SQL Server Connection

The Internet Information Server then passes the results of the query to the
client web browser.

Additional query words: prodiis winnt
======================================================================
Keywords          : kbnetwork 
Technology        : kbiisSearch kbiis100
Version           : 1.0 3.51

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1999.