Sunday, February 19, 2012

How to access SQL Server on another domain with Windows authentica

I have two computers, client and server. The client is running Windows 2000
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonating
a domain user on the server from the client (which is not in the domain, just
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.First try setting the same user and password on both pc and server
login to the pc with the new you name.
Second to your seft to the domain in admin group
I hope this Helps
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:7DD371D4-22DB-465A-89A3-B3F5DEDEA474@.microsoft.com...
> I have two computers, client and server. The client is running Windows
2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
Impersonating
> a domain user on the server from the client (which is not in the domain,
just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.|||Your options are:
1) Set the passwords and usernames the same on the local machine in the
workgroup and the domain
2) Use named pipes to connect and Pre-Authenticate (like with a net use
\\server /user:domain\user password) before connecting to sql
3) use sql std logins

No comments:

Post a Comment