P
Phil Jewett
I have an Access 2000 mdb that uses SQL Server 2000 (mixed
mode) authentication to link to the SQL database, with a
typical ODBC connection string with the SQL login name and
password, and not requesting a trusted connection. Works
fine on Windows 98 and 2000 boxes, but on Windows XP the
mdb fails, with a Microsoft Sql Server Login error stating
the login failed for 'mydomain/myusername', which is
expected since the network accounts are not set up in the
database. Clicking OK brings up the standard SQL Server
2000 login screen, with the 'use trusted connection' box
checked. I can uncheck the box and put in the SQL login
id/password to login, but how can I avoid the problem in
the first place?
mode) authentication to link to the SQL database, with a
typical ODBC connection string with the SQL login name and
password, and not requesting a trusted connection. Works
fine on Windows 98 and 2000 boxes, but on Windows XP the
mdb fails, with a Microsoft Sql Server Login error stating
the login failed for 'mydomain/myusername', which is
expected since the network accounts are not set up in the
database. Clicking OK brings up the standard SQL Server
2000 login screen, with the 'use trusted connection' box
checked. I can uncheck the box and put in the SQL login
id/password to login, but how can I avoid the problem in
the first place?