Remote Indexing / Distributed Query
From: MadMax (anonymous_at_discussions.microsoft.com)
Date: 06/09/04
- Next message: Mike Hennessy: "Re: querying multiple columns in FT on Yukon?"
- Previous message: John Kane: "Re: Inflectional and/or not returning the correct results"
- Next in thread: MadMax: "RE: Remote Indexing / Distributed Query: It works.."
- Reply: MadMax: "RE: Remote Indexing / Distributed Query: It works.."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 00:26:02 -0700
Hi guys,
I'm trying to access an Indexing Service located on a remote machine using
the distributed query functionality of MS-SQLServer.
On a newsgroup on Goggle I found an old article in which it was described
a configuration that I replicated but with no lucky.
I have two Windows 2000 (SP4) boxes with MS-SQLServer 2000 Enterprise Ed. (SP3).
On the first server (server1), the Indexing Server is up & running;
the service is configured using Local System Account and is allowed
to interact with the desktop.
On the second box (Server2), the Indexing Service is stopped. I've configured
a linked server using the following system procedure call:
sp_addlinkedserver FileSystem, 'Index Server', 'MSIDXS', 'System'
Then, using SQL Query Analyzer connected with Server2, I run this statement:
SELECT * FROM OPENQUERY(FileSystem, 'SELECT Directory, FileName,
DocAuthor, Size, Create, Write
FROM server1.System..SCOPE ('' "c:\" '') WHERE CONTAINS(''microsoft'') '
)
It fails providing the following messages:
Server: Msg 7399, Level 16, State 1, Line 1
Provider OLE DB 'MSIDXS' signaled an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: Invalid catalog name 'SYSTEM'. SQLSTATE=42000 ]
OLE DB Error Trace [OLE/DB Provider 'MSIDXS' ICommandPrepare::Prepare returned 0x80004005: ].
Note that if I open SQL Query Analyzer on server1 and I run the same statement
(a sort of loop-back ?!?), the query works fine.
Do you know what is going on ?
I'm wondering if this kind of configuration is supported. Looking in the documentation
I wasn't able to find any answer. Do you know if, for MSIDXS OLE/DB provider, the
distributed query facility is limited to the server where both SQLServer and Indexing
Server are running ?
As you know, indexing is a quite expansive task; so I would like to perfom it on a
dedicated server. If distributed query doesn't address this scenario, can I use
something else ? I also tried some ADO programming, but I found no way to specify
a remote source in the connnection string: does the MSIDXS provider support only
local connection ?
Many thanks for your kind reply
Max
- Next message: Mike Hennessy: "Re: querying multiple columns in FT on Yukon?"
- Previous message: John Kane: "Re: Inflectional and/or not returning the correct results"
- Next in thread: MadMax: "RE: Remote Indexing / Distributed Query: It works.."
- Reply: MadMax: "RE: Remote Indexing / Distributed Query: It works.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
