Microsoft KB Archive/244531

= FIX: SQL DSN Reverts from Standard Security to Integrated Security =

Article ID: 244531

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft ODBC Driver for Microsoft SQL Server 3.7

-



This article was previously published under Q244531



BUG #: 56502 (SQLBUG_70)



SYMPTOMS
Using ODBC Administrator, If you reopen an existing SQL Server DSN and click Finish on the first screen, it may revert the security mode from standard SQL security to integrated security. This may cause login failure when you connect to SQL Server if the requirements for Windows NT Authentication are not satisfied.



RESOLUTION
The workaround is not to click Finish on the first screen when you edit an existing SQL Server DSN. If you go through the other screens during second edit of DSN, the problem will not occur.



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

This problem was corrected in MDAC 2.6.



Steps to Reproduce the Problem

 * 1) Set up a DSN using SQL Server ODBC driver with standard SQL security.
 * 2) On the last screen, click Finish and make sure the Use Integrated Security attribute is selected as "No".
 * 3) Click OK to save the DSN.
 * 4) Reopen the DSN and click Finish on the first screen, notice the Use Integrated Security attribute has changed to "Yes".
 * 5) Test fails if you are logged on as a non-admin account.

Keywords: kbbug kbfix kbmdac260fix kbmdacnosweep KB244531

-

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

© Microsoft Corporation. All rights reserved.