This post was formerly published at my beloved old blog "On the quest of a DBA's adventure......"
Thanks to Derek Dieter, he puts up a post on How to Add a Linked Server. Very simple and straight forward.
What my problem is that I keep forgetting that when you are setting up a linked server which is another SQL Server, make sure that "Other Data Source" is chosen for the "Server Type" option instead of "SQL server". Rare, isn't it? I have so many times thought let's use the option "SQL Server" since it is natively a SQL server target. But it is always failed on me, until I refered back to Derek's post.
No comments:
Post a Comment