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.
5  2671 
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" <go****@webpaul .net> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. . 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.
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" <go****@webpaul .net> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. . 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.
pb648174 (go****@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, es****@sommarsk og.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 (go****@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, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sudhesh Nayak |
last post by:
Hi,
I have an Oracle (8.1) & a SQL Server 2000 database with
Production data. There are situations when I need data from both the
databases. My first choice was to link Oracle to SQL and run DTS
overnight. But this would have a 1 day latency not to mention the time
it would take.
1. Has any one tried real time access via Linked server to Oracle?
How good is the performance?
|
by: Michael Bourgon |
last post by:
I've been having the same problem for 2 weeks now. If anyone has any
ideas, I'd love to hear them. We are using both SQL and Windows
Authentication. I was running a Profiler Trace at the time, and am
going through it now but have not seen anything yet.
Thanks in advance.
About once a week, at no fixed time (but so far, between 8am and
11am), my SQL Server 2000 on Windows 2000 (8.00.679) will stop
responding. New connections will...
|
by: Bill J. |
last post by:
I have to update a PostgreSQL linked server through MSSQL2K.
I first configured the connection with ODBC as follows and I can do queries
with no problem:
EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL
GO
EXEC sp_DropServer 'PostgreSQL'
GO
|
by: Bill J. |
last post by:
I have to update a PostgreSQL linked server through MSSQL2K.
I first configured the connection with ODBC as follows and I can do queries
with no problem:
EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL
GO
EXEC sp_DropServer 'PostgreSQL'
GO
|
by: Amanda |
last post by:
From a guy in Microsoft newsgroups:
| In *comp.databases.ibm-db2* there are always IBM guys
| from the Toronto labs on line.Post with the
| -for the love of god please help-
| line and I'm sure you'll get their attention.
| Their usually very good:)
So here's my transplanted post
==========================================
| | |
by: Hemant Shah |
last post by:
Folks,
How many tcp ports does DB2 server use?
I installed UDB 8.2 on a AIX system and created several instances.
I used consecutive ports for each instance, but when I look at
/etc/services file, it seems that db2icrt command adds 4 ports for each
server.
Example:
|
by: Neil |
last post by:
I am getting time-out errors when I try to perform a simple delete on a
linked server. The command is:
Delete From MyTable Where PKID=12345
I have tried executing this command directly from Query Analyzer, but it
just times out. However, when I run it from QA against the server itself
(rather than from my local server against a linked server), it executes
immediately. Similarly, if I run the same SQL command through an ODBC linked...
|
by: joaquimfpinto |
last post by:
Dear All,
I made an app in c# that uses several serial ports.
For the serial ports I use a pnp Sunix board, some with 8 serial ports
other with 4 or even 2 serial ports.
Whenever I use the development computer I don't have ay problem with
my application.
|
by: mochinushi |
last post by:
Im a newb C++ programmer trying to figure out what concepts and protocols i should be reading on... What im trying to accomplish is a "stealth" tunnel/forwarder from my computer at the dorm to a remote vps. By stealh i mean so that the evil admin doesnt see what im doing :P
First i used ssh tunneling but he noticed the excessive traffic on port 22 and forbid any use of tunneling/encryption stuff :/
Im quite a noob when it comes to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
