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.

Doing demos with SQL2K RS Developer

Hi there.
I need to know if there's a proper setup to have SQL 2k Developer Edition
and SQL 2k RS Developer Edition on top of Win XP Pro to demo some reports.
I have locally installed VS .Net 2003 professional, SQL 2K Developer, SQL 2K
RS Developer, SQL 2K AS and IIS on top of Windows XP and RS does not ran if
I'm not connected to corporate network.
I have no way to make RS work on the road or at customers networks to show
some nice reports we have built...
I even installed SQL 2K RS Sp1 and it has no effect
Do I need to format my notebook and Install Win 2000?
Is it a setup problem?
Is it a licensing restriction?
Thank you very much for your support
Michael PrendergastSearch this newsgroup for "loopback":
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/search?group=microsoft.public.sqlserver.reportingsvcs&q=loopback&qt_g=1&searchnow=Search+this+group
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"MPS" <mps@.udd.cl> wrote in message
news:u$M4kf29EHA.2996@.TK2MSFTNGP10.phx.gbl...
> Hi there.
> I need to know if there's a proper setup to have SQL 2k Developer Edition
> and SQL 2k RS Developer Edition on top of Win XP Pro to demo some reports.
> I have locally installed VS .Net 2003 professional, SQL 2K Developer, SQL
> 2K RS Developer, SQL 2K AS and IIS on top of Windows XP and RS does not
> ran if I'm not connected to corporate network.
> I have no way to make RS work on the road or at customers networks to show
> some nice reports we have built...
> I even installed SQL 2K RS Sp1 and it has no effect
> Do I need to format my notebook and Install Win 2000?
> Is it a setup problem?
> Is it a licensing restriction?
> Thank you very much for your support
> Michael Prendergast
>