September 4, 2007 at 4:03 pm
I have a peculiar issue that I am facing I need to create a linked server from SQL Server in one network to network server on the other network. The machine name does not work since it is not on the same network and so I have to use fully qualified name is wpdwd556.dev.xxx.xx.xxx.com. Now if I try to use the full name eventhough it created linked server but then when i do a query select * from wpdwd556.dev.xxx.xx.xxx.com.dbname.dbo.tablename it given me an error.
When I try to use only the machine name it gives me error Named Pipes Provider: Could not open a connection to SQL Server [53] and reason code 53 which means network path not found.
My network people are telling me that The port to the DB is open to this server. It just cannot resolve the server name without it being the FQDN (fully qualified domain name)
Any suggestion would be greatly appreciated
September 4, 2007 at 4:19 pm
try creating an alias in the local SQL Server that points to the actual machine name. Then use the alias as the server name of the linked server.
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply