Microsoft KB Archive/148237

= IDC: Error Performing Query Connecting to SQL Server =

Article ID: 148237

Article Last Modified on 6/23/2005

-

APPLIES TO


 * Microsoft Internet Information Server 1.0
 * Microsoft Internet Information Server 2.0
 * Microsoft Internet Information Server 3.0
 * Microsoft Internet Information Server 4.0

-



This article was previously published under Q148237



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 execute an IDC script that connects to a remote SQL Server, one of the following error messages appear from the web browser:

Error Performing Query

[State=01000][Error=1385][Microsoft][ODBC SQL Server

Driver][dbnmpntw]ConnectionOpen (CreateFile).

[State=08001][Error=1385][Microsoft][ODBC SQL Server Driver]Unable

to connect to data source

-or-

[State=01000][Error=1326][Microsoft][ODBC SQL Server

Driver][dbnmpntw]ConnectionOpen (CreateFile).

[State=08001][Error=1326][Microsoft][ODBC SQL Server Driver]Unable

to connect to data source



CAUSE
This problem occurs because of one or all of the following:


 * The user account IUSR_ (where  is the name of your Internet Information Server) does not have the "Access this computer from the network" user right configured on the SQL Server.
 * The Internet Information Server and the SQL Server are on different domains and the IUSR_ account does not exist in the SQL Server's local user database or domain.
 * The Internet Information Server and SQL Server are on the same domain; however, the Internet Information Server is installed on a Server (non-domain controller) and the SQL Server is installed on a Domain Controller. The IUSR_ account does not exist on the domain.



RESOLUTION
To correct this problem, do one or all of the following:

 Grant the IUSR_ the "Access this computer from network" user right on the SQL Server. If there is a trust established between the domains, whereas the Internet Information Server in the Resource domain, then you can set the "Username:" value under "Anonymous Logon" to be MASTERDOMAIN\username (where username is a user account that was created on the Master Domain).

If there is not a trust relationship involved, you must create an IUSR_ account on the remote domain and give it the appropriate rights. (See first resolution above)

Note: If there is no trust, the username and password in one domain must match the username and password on the other domain.  Modify the "Username:" value under "Anonymous Logon" in the Microsoft Internet Service Manager to use the following format:

<pre class="fixed_text">     DOMAIN\IUSR_<Server Name>.

If the IUSR_<Server Name> does not exist on the domain, then create the account using User Manager for Domains. </li> See 141086 in the SQL Server Knowledge Base for information on fixing a bug in the SQL Server 2.5 ODBC driver.</li></ul>

<div class="moreinformation_section">

MORE INFORMATION
The Internet Information Server accesses the SQL Server by first connecting to the IPC$ share of the SQL Server. It uses the user name and password specified for Anonymous Logon (entry is in the Service tab of Internet Service Manager).

Additional query words: prodiis

Keywords: kbnetwork KB148237

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.