Have three xp machines running Office XP Pro with an AccessXP front-end connecting to an sql7 on nt4 back-end. The odbc file dsn is located in the same folder as the mdb on a server (for regular backups). All machines are running same version of sql driver 2000.81.9042.00
Two connect just fine all the time. One cannot connect - ever. If we place him into the NT4 domain admin group, he can connect at another machine fine. If he's at his machine - he cannot connect ever.
The same sql account is used on asp pages by non-administrators just fine.
How can I get this guy out of the Domain Admin Group and still have him connect using sql authentication?