actually i am working on distributed database.

and i want to have location transaparancy at my application level.

That problem is solved .

actually IPX/SPX protocol was not added to allowed protocol list.

But now i am getting a different error when i am trying to execute a...

i am able to connect to other server and fire a query. its working fine.

But its not working with Linked servers

i logged into the remote server using remote desktop connection and then I fired a query

select * from username

where username is a tablename

then it is displaying all the rows in...

yes for both servers in properties/security sqlserver and Windows Authentication is selected

still it is showing the same error

I had tried with both options

1)be made using the login's current security context

2)be made using this security context

no even then its showing the same error