Home Project Bookmarks Training Fix Tools Documents Search TOC Components Members Sayings


  • When attempting to Upsize an Access DB to MSDE in preparation for the eventual migration to SQL Server.
  • If attempting to access the DB via ADO you might be receiving the following error: Microsoft OLE DB Provider for SQL Server error '80004005' Login failed for user 'sa'. Reason: Not associated with a trusted SQL=20 Server connection.
  • You can change the authentication to "SQL Server and Windows" by changing this registry setting:
      • LoginMode = 1  
        • Forces MSDE to use "Windows Only" Authentication
      • LoginMode = 2 
        • Allows MSDE to use "SQL Server and Windows" Authentication

Copyright 2002 - 2003 XOCOMP, llc
Contact: or after March 2003

All materials and notes are the intellectual property of XOCOMP with expressed permission for use by PROTOCOL.