Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remote Admin to a Linked Server

Status
Not open for further replies.
billoddie

billoddie

Technical User
Dec 16, 2001
3
AU
I need help using a remote admin to another SQL Server...

Lets say I am using SQLServerA on MachineA, I have a remote login to SQLServerB on MachineB (giving me full administrator rights).

SQLServerB has a Linked Server (LinkedServerB1) to a local AccessDB (stored on MachineB).
From SQLServerA on MachineA I can get full access to the tables in LinkedServerB1 (and use them in views, etc).

SQLServerB also has a Linked Server (LinkedServerB2) to a second AccessDB (stored on another server on the network (MachineC)).
The problem is from SQLServerA on MachineA I cannot get access to LinkedServerB2.

SQLServerB on MachineB CAN access the LinkedServerB2 and its tables with no problems.

What could be the problem, Security, NT Logon??? or is it possible to do this at all??

It may help to undrstand this problem if you draw a diagram!!!
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
526
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
821
Volvere
V
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
824
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
2K
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
919
SashaBuilder3
SashaBuilder3

Part and Inventory Search

Sponsor

Back
Top