Re:Distributed Queries

From: Vishal Parkar (vgparkar@hotmail.com)
Date: 11/18/02 

From: "Vishal Parkar" <vgparkar@hotmail.com>
Date: Sun, 17 Nov 2002 23:06:12 -0800

Make sure the current connection you've made to local
server is through Windows NT login and this Username has
right to connect to remote server, or User name is added
as a login on remote server and has appropriate rights to
access the database.

--Vishal

>-----Original Message-----
>
> I have written a com+ component which basically executes
>SQL Queries.
>
> The set up that i have is as follows.
>
> Two Machines with SQL server 2000 installed.
>
>what i want to do is copy tables from one database on
>source to target machine database.
>
>Query which i am running is as follows
>
>INSERT INTO dbnames.dbo.tablename
>SELECT * FROM OPENDATASOURCE('SQLOLEDB','INTEGRATED
>SECURITY=SSPI;Server=Vikraml').dbnames.dbo.tablename
>
>Com+ component is always connected to target SQL Server db
>When is run this query from the com+ component from the
>source machine it gives me a error
>
>Login Failed NT Authority / Anonymous logon
>
>I have already set authentication modes for both Servers
>to Windows Authentication.
>
>
>
>
>
>.
>

Relevant Pages

  • Re: ASP.NET User.Identity.Name value after a domain username chang
    ... Since .NET is just calling into Windows API calls to resolve the user name, ... I have an ASP.NET application that is on a Win2000 server in a domain ... I have a very confusing issue when the domain login of a user is ... I thought this might have been some caching issue on the client so I ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER TH
    ... Having a user login to a windows 2003 server over the internet is not a good ...
    (microsoft.public.windows.server.active_directory)
  • Re: Win2003 Console Login Screen Black- Cant Log In
    ... it discovered the existing install, ... > I've got a Windows 2003 Standard server. ... This is also our Veritas Netbackup server. ... > black screen with only part of the login prompt showing. ...
    (microsoft.public.windows.server.general)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER THE IN
    ... If I create a user in active directory in windows 2003 server, ... login to that user using windows xp login dialog box within the network ... and you can resolve DNS from the point of view of an INTERNAL ...
    (microsoft.public.windows.server.active_directory)