[AccessD] Access 2002 insists on SQL Server trusted connectio n

Haslett, Andrew andrew.haslett at ilc.gov.au
Wed Nov 12 02:51:46 CST 2003


Are you sure the SQL Server itself isn't set to 'Windows Mode'?  If so it
needs to be set to 'Mixed Mode' to accept SQL authentication..

Cheers,
Andrew

-----Original Message-----
From: Phil Jewett [mailto:pjewett at bayplace.com]
Sent: Wednesday, 12 November 2003 1:05 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 2002 insists on SQL Server trusted connection


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!  See
http://support.microsoft.com/default.aspx?scid=kb;en-us;279526 for MS's
info.  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

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.


More information about the AccessD mailing list