TCP/UDP ports used for Index server OpenQuery

If I am doing an Index Server query from SQL, such as:
SELECT
Q.*
FROM
OPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcount
FROM SCOPE('DEEP TRAVERSAL OF .....

can anyone tell me which TCP/UDP ports will be used between the SQL
Server and the Index server if the Index Server is on another machine?
I'm doing the query from SQL so that I can join the results with a
table in the database and am not interested in doing the Index query
from the app server. I haven't been able to find any info on the net
for which firewall ports are used for this.

Hi,

This should help:
http://groups.google.co.uk/group/mic...8b8b4d38960487

Tony.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"pb648174" <google@webpaul.net> wrote in message
news:1131036399.023509.254420@g44g2000cwa.googlegr oups.com...
> If I am doing an Index Server query from SQL, such as:
> SELECT
> Q.*
> FROM
> OPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcount
> FROM SCOPE('DEEP TRAVERSAL OF .....
>
> can anyone tell me which TCP/UDP ports will be used between the SQL
> Server and the Index server if the Index Server is on another machine?
> I'm doing the query from SQL so that I can join the results with a
> table in the database and am not interested in doing the Index query
> from the app server. I haven't been able to find any info on the net
> for which firewall ports are used for this.
>

This actually isn't relevant - The below problem was with the Index
server on one machine crawling the files on another. What I am trying
to achieve is a connection to a remote index server, which is on the
same machine as the files. So I shouldn't need the standard UNC/File
share ports, but rather something to do with OLEDB.

Tony Rogerson wrote:
> Hi,
>
> This should help:
> http://groups.google.co.uk/group/mic...8b8b4d38960487
>
> Tony.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
>
> "pb648174" <google@webpaul.net> wrote in message
> news:1131036399.023509.254420@g44g2000cwa.googlegr oups.com...
> > If I am doing an Index Server query from SQL, such as:
> > SELECT
> > Q.*
> > FROM
> > OPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcount
> > FROM SCOPE('DEEP TRAVERSAL OF .....
> >
> > can anyone tell me which TCP/UDP ports will be used between the SQL
> > Server and the Index server if the Index Server is on another machine?
> > I'm doing the query from SQL so that I can join the results with a
> > table in the database and am not interested in doing the Index query
> > from the app server. I haven't been able to find any info on the net
> > for which firewall ports are used for this.
> >

pb648174 (google@webpaul.net) writes:
> This actually isn't relevant - The below problem was with the Index
> server on one machine crawling the files on another. What I am trying
> to achieve is a connection to a remote index server, which is on the
> same machine as the files. So I shouldn't need the standard UNC/File
> share ports, but rather something to do with OLEDB.

You would need to set up the linked server as you would set your
connection string in a client program that connected directly to
Index Server.

No, I don't know how to that, since I hardly know what Index Server is.
But the point here is that if you don't know how to connect to Index
Server, you should try to find a forum for this product, where people
might know.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

The first example I gave is exactly how you connect to index server,
and it works fine. My questions is omply that once there is a firewall
inbetween the two, what will the ports needed be..

pb648174 (google@webpaul.net) writes:
> The first example I gave is exactly how you connect to index server,
> and it works fine. My questions is omply that once there is a firewall
> inbetween the two, what will the ports needed be..

That would be the ports on the Index Server box. SQL Server is only
connecting out. Index Server does not connect back. (And if it does it
connects to the OLE DB Provider.)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp