[AccessD] SQL trusted connection problem

Hi Phil:

Check the following out in your registry. If a similar entry does not exist
add this entry in, to the client stations:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSERVER\Client\ConnectTo]"MyServe
r"="DBNMPNTW,MyServer"

Had to run an automated process on almost sixty stations about a year ago.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Phil Jewett
Sent: Wednesday, November 12, 2003 9:36 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] SQL trusted connection problem


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



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com