[AccessD] Re: SQL trusted connection problem

How is your ODBC DNS set up?

Are you storing the password in it?

Is the SQL Server set up to do mixed mode?


At 12:00 PM 11/12/2003 -0600, you wrote:
>Date: Wed, 12 Nov 2003 09:36:18 -0800
>From: "Phil Jewett" <pjewett at bayplace.com>
>Subject: [AccessD] SQL trusted connection problem
>To: <accessd at databaseadvisors.com>
>Message-ID:
>         <D3C4180250579C42A9C6A5A199772138068B5B at comet.home.bayplace.com>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>When I run my Access 2000 frontend on a Windows XP/Access 2002 box, the
>SQL Server 2000 login fails, insisting on the 'trusted connection'
>network login instead of the SQL Server authentication in the ODBC
>connection string.  This was presumably fixed in MDAC 2.6 SP2 - but
>maybe only for Access 2000.  It's still there for Access 2002!  This
>problem is discussed in
>http://support.microsoft.com/default.aspx?scid=kb;en-us;279526 .  Any
>help on this?
>
>Thanks,
>
>Phil Jewett