We have a linked server that works from one server A to Server B, but wont work from other machines, i.e. if you log onto server A, the link shows the databases and catalogs, you can test the link and it works, log onto another machine via SSMS and connect to server A and the same operation does work, am using the same login and the security is set to "Be made usign the login's current security context"
The protocols are all enabled, its set up for remote connections, cant understand it !
Any suggestions ?