Domain to Workgroup connections

Hello everyone,
Here's the setup:
I'm trying to get an basic ADO application on my
workstation (Win2K Pro, on a domain), to talk to SQL 2000
on a server (Win2K Server, on a workgroup all by itself).
The SQL server is using Windows Authentication.
Any ideas how I can get this to work? Our application is
capable of 'impersonating' other users, but when I get it
to impersonate MYSERVER\Administrator it just says the
user id / password is invalid.
Can't get query analyser to talk to the server at all.
Thanks,
Mark.
The only way to make this work is to have identical usernames and password
on both machines. In other words, the Administrator account on the Worgroup
machine has to have the same password on the MYSERVER domain. This should
allow passthrough authentication to work.
Rand
This posting is provided "as is" with no warranties and confers no rights.