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.

Domain to workgroup connections

Hello everyone,
Here's the setup:
I'm trying to get a 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.This may be a Windows authenication issue alone. If you set up a local accou
nt on the workstation, then set up the same local account with the same pass
word on the server, then run your app with the local account. This setup wil
l allow your workstatino to
talk to the server (I'd try to get query analyser to work under this configu
ration first). This is a feature of Windows to allow standalone computers to
authenicate users.
Don't know how your app implements 'impersonating'. So 'impersonating' the l
ocal account under your app may or may not work.
-- Mark Hutchings wrote: --
Hello everyone,
Here's the setup:
I'm trying to get a 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.