• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Linked Server in SQL2005 not connecting.

I have tried everything to get a linked server running.  I can sign onto the servers when I am on the physical box.  But when I create a linked server from one to the other, I get error messages.  One message references the allow remote connections ( I have it checked)  Then it says named pipes is a problem.  I changed it to TCPIP.  I can ping one server to the other.
I have played with this all day.  Does anyone know what I am missing or what I should look at?

1 Solution
Could you please post the complete error message here?
JanSrItAuthor Commented:
I figured it out myself while waiting for an answer

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now