problem with federated server linking

[majidkhan]

Hello everyone.

I am trying to implement linked servers and I am having some trouble. The setup is as follows: I have two machines with the same SA login/pwd. BOTH machines have a database called: Federated_Bridge.

On machine 1: Federated_Bridge contains a table Fed_Entity_1

On machine 2: Federated_Bridge contains a table Fed_Entity_2


Machine 1, when I look it up in SQL Enterprise Manager it says: (local)

Machine 2, when I look it up in SQL Enterprise Manager it says: REALIBM2


When I expand those, I can see the databases folder and I can then see Federated_Bridge respectively.


On machine 1 (local) I am trying to create a linked server. I use the following SP call:

---------

use master
go
EXEC sp_addlinkedserver
@server = 'TEST3',
@srvproduct = 'SQLServer OLEDB Provider',
@provider = 'SQLOLEDB',
@datasrc = 'REALIBM2\Federated_Bridge'


EXEC sp_addlinkedsrvlogin 'TEST3', 'false', 'sa', 'sa', 'mysapwd'

--------

The above queries seem to execute fine. Afterwards, when I check in Enterprise manager, I can see under linked servers TEST3 .. but no tables or views are showing.

When I run the following select query from query analyzer, I get an error message:


SELECT * FROM Test3.Federated_Bridge.dbo.Fed_Entity_2

SQL Server Does Not Exist Or Access Denied


Please help!!

Thanks.

[rmiao]

What's 'REALIBM2\Federated_Bridge'? Is it sql instance name? Tried create linked server in em?