Monday, February 20, 2012

Linked server

Our SQL Server has a linked server that we are trying to query.
Our SQL-Server is on a DMZ-net, behind an ISA-Server, the linked server is
not behind any firewall.
I have no problem to make a connection as a linked server from my local
workstation (not on the DMZ-net).
Does anybody know which port that are used by the connection to a linked
server?By default it should be using port 80, i recommend it would be good for you
to have a look at this presentation:
http://www.appsecinc.com/presentati...ion
.pdf
It has some very good explanations on how the linked and remote servers in
MS SQL Servers allows one server to communicate... have a look.
cheers,
Gleuto Serafim, PhD
Infrastructure Architect
"Tullamore" wrote:

> Our SQL Server has a linked server that we are trying to query.
> Our SQL-Server is on a DMZ-net, behind an ISA-Server, the linked server is
> not behind any firewall.
> I have no problem to make a connection as a linked server from my local
> workstation (not on the DMZ-net).
> Does anybody know which port that are used by the connection to a linked
> server?
>
>|||By default it should be using port 80, i recommend it would be good for you
to have a look at this presentation:
http://www.appsecinc.com/presentati...ion
.pdf
It has some very good explanations on how the linked and remote servers in
MS SQL Servers allows one server to communicate... have a look.
cheers,
Gleuto Serafim, PhD
Infrastructure Architect
"Tullamore" wrote:

> Our SQL Server has a linked server that we are trying to query.
> Our SQL-Server is on a DMZ-net, behind an ISA-Server, the linked server is
> not behind any firewall.
> I have no problem to make a connection as a linked server from my local
> workstation (not on the DMZ-net).
> Does anybody know which port that are used by the connection to a linked
> server?
>
>

No comments:

Post a Comment