Monday, March 12, 2012

Linked Server connection problem

I have a SQL 2K Server that is behind a substacial
firewall, and I am trying to setup a Linked Server between
it and a SQL 2K server on a host site. I can set up the
link just fine frm my SQL 2K server at home, but am unable
to make the link from the SQL server at work. The firewall
is the suspect.
I have talked to our router guys and they report that when
I try to make the link, ports 445 and 139 are attempting
communication. These ports are specifically blocked by Net
Ops here.
My question is this, does the Linked Server proccess
require communications over these ports, or should I look
for another culprit '
ANY help is greatly appreciated !!!
Thanks.
Michael.SQL server uses port 1433 by default. Make sure it is
open on the firewall or spell out a different port to use
with your "Client Network Utility" and "Server Network
Utility"
>--Original Message--
>I have a SQL 2K Server that is behind a substacial
>firewall, and I am trying to setup a Linked Server
between
>it and a SQL 2K server on a host site. I can set up the
>link just fine frm my SQL 2K server at home, but am
unable
>to make the link from the SQL server at work. The
firewall
>is the suspect.
>I have talked to our router guys and they report that
when
>I try to make the link, ports 445 and 139 are attempting
>communication. These ports are specifically blocked by
Net
>Ops here.
>My question is this, does the Linked Server proccess
>require communications over these ports, or should I look
>for another culprit '
>ANY help is greatly appreciated !!!
>Thanks.
>Michael.
>.
>

No comments:

Post a Comment