• 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:
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer=
    • 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: md3@protocolla.com or md3@xocomp.net after March 2003

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