So you want to set up a linked server through Management Studios? Great! I’m sure you’ve got your steps down, too:
Step 1: Open Management Studios
Step 2: Click Server Objects, right click Linked Servers, and select “New Linked Server”
Step 3: Enter the correct name of the server being linked to
Step 4: Enter the correct log-in credentials
Step 5: Click “OK”
But wait, what’s this?
This message seems pretty straight forward. But how to resolve it? Well, after an exhaustive search of the interwebs and her many pages of false hope, I have found the answer: Firewalls. That’s right. Firewalls. It’s so simple!
Run wf.msc on the machine you’re trying to link to. This will open Windows’ firewall snapin.
On inboundrules, add a new rule.
When asked what kind of rule you want to create, select “Port.”
Specify the port 1433.
Under “Action,” select “Allow Connection.”
The Profile page defines where you want this rule to apply (domain, private, and public are the options, but I’m always wary to allow public. You can deselect this without causing further problems).
Finally, name your rule and click finish.