Microsoft KB Archive/817844

= BUG: OLEDB Connections from Windows 2000 or Windows NT Do Not Succeed When NT Authentication is Used =

PSS ID Number: 817844

Article Last Modified on 5/5/2003

-

The information in this article applies to:


 * Microsoft Data Access Components 2.7 SP1
 * Microsoft SQL Server 2000 (all editions) SP3

-



SYMPTOMS
You cannot connect to SQL Server, and you receive an incorrect error message in the following circumstances:
 * You use NT authentication on a Windows 2000-based computer or in a Windows NT-based computer while connecting to SQL Server.
 * You do not specify the UID.

You may receive the following incorrect error message:

Error Code -2147217843 : Login failed for user



CAUSE
The error occurs because when NT Authentication is used, the application does not set the User ID property automatically to connect to SQL Server.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



RESOLUTION
A supported fix is now available from Microsoft, but it is only intended to correct the problem described in this article. Only apply it to systems that are experiencing this specific problem. This fix may receive additional testing to further ensure product quality. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next Service Pack that contains this fix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.



MORE INFORMATION
Even after you install the QFE, you will not be allowed to connect to the SQL Server if you do not pass User ID. However, instead of the error described in the &quot;Symptoms&quot; section, you receive

Invalid authorization specification

error.

