So you created a linked server on your local instance which points to BLXCQA\X86 and when you try to reference the linked server you get a login failed error? How is your linked server configured? Can you access BLXCQA\X86 directly? Take a look at BLXCQA\X86's SQL Server Logs (under object explorer | Management). You should see the login error and a reason for the error. If there is additional codes reported then google for that error including the code and you'll get a lot more info.
Query Linked Server from Local Machine
Posted - 03/12/2013 : 10:52:19
