Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fredforfree
Starting Member
49 Posts |
 Posted - 2013-03-12 : 10:52:19
|
| Hello,I am working on Local Machine EG1FRD and I need to query data from another server that I have read only access, FSQL.INT.SAM.CAThe data on the remote server is in a Linked Server called ISMHow can I do this?Thank you Fred |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-03-12 : 11:20:57
|
| 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.Be One with the OptimizerTG |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Query Linked Server from Local Machine