i need to consult this issue am having with linked server.
i setup a linked server from server1 to server2. currently there already N number of linked servers connecting to server2 from other sql servers. my problem is that my newly created (from my ssms on my pc) linked server from server1 to server2, it returns login failed for user 'null'. but when i try to connect to server1 via remote desktop, open up ssms, go to server objects and test the linked server connection, everything is working!
appreciate any help extended. i've been working on this for half a day now. btw, all sql are windows auth, and i'm using my domain account to login to remote desktop.