TCP/UDP ports used for Index server OpenQuery

[pb648174]

If I am doing an Index Server query from SQL, such as:
SELECT
Q.*
FROM
OPENQUERY(FTInd exPM, ''SELECT path, characterizatio n, 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.

[Tony Rogerson]

Re: TCP/UDP ports used for Index server OpenQuery

Hi,

This should help:

http://groups.google.co.uk/group/microsoft.public.inetserver.indexserver/browse_frm/thread/d7f25379a78daf4b/8d8b8b4d38960487?lnk=st&q=%22index+server%22+tcp+ports&rnum=3&hl=en#8d8b8b4d38960487

Tony.

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


"pb648174" <google@webpaul .net> wrote in message
news:1131036399 .023509.254420@ g44g2000cwa.goo glegroups.com.. .[color=blue]
> If I am doing an Index Server query from SQL, such as:
> SELECT
> Q.*
> FROM
> OPENQUERY(FTInd exPM, ''SELECT path, characterizatio n, 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.
>[/color]

[pb648174]

Re: TCP/UDP ports used for Index server OpenQuery

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:[color=blue]
> 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.goo glegroups.com.. .[color=green]
> > If I am doing an Index Server query from SQL, such as:
> > SELECT
> > Q.*
> > FROM
> > OPENQUERY(FTInd exPM, ''SELECT path, characterizatio n, 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.
> >[/color][/color]

[Erland Sommarskog]

Re: TCP/UDP ports used for Index server OpenQuery

pb648174 (google@webpaul .net) writes:[color=blue]
> 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.[/color]

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@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[pb648174]

Re: TCP/UDP ports used for Index server OpenQuery

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..

[Erland Sommarskog]

Re: TCP/UDP ports used for Index server OpenQuery

pb648174 (google@webpaul .net) writes:[color=blue]
> 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..[/color]

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@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp