Linked Server Problem

From: Mid Damian (middamian@yahoo.com)
Date: 08/23/02 

From: middamian@yahoo.com (Mid Damian)
Date: 22 Aug 2002 22:10:13 -0700

I have a SQL Server 2k (User1) with a linked server
(User2-impersonate) that wroks well (the 2 computers are in 2
different domains). I did exactly the same setup on a different SQL
Server to the same linked server (the 2 computers are in the same
domain), but this does not work. The message says that User1 failed to
be authenticated, it looks like the impersonation does not happen! I
am completely lost! Please help!
Thanks.
Mid

Relevant Pages

  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • Re: Microsoft Excell Connection
    ... Use your linked server to Access then as the source by adding a SQL Server ... You should be able to add an Access Connection to a secured Access MDB ... properties enter the location of your system database. ...
    (microsoft.public.sqlserver.dts)
  • Re: ODBC Linked Server & DSN
    ... You will need to setup the driver and DSN on the SQL Server machine. ... I'm attempting to setup a linked server in SQL Server 2005 to an ODBC ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 linked server problem
    ... The delegated Kerberos authentication does not work stably. ... of SQL Server 2000 to fix some known bugs on the SQL Server side. ... the both two SQL Server instances (local and linked server), ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)