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.