Access Indexing Services on a different machine

[vbkris]

Hi,

I would like to access in my SQL Server an indexing service that runs on a different system using Linked Servers.

What are the steps i need to take to achieve this?

The idea is to search through files for keywords on a different system using queries (this result will later be linked to a normal query)...

Known is handfull, Unknown is worldfull

 

[mrdenny]

You would need to ask the folks that wrote the indexing service that you are using. They can tell you how to make a linked server to it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[vbkris]

>>You would need to ask the folks that wrote the indexing service that you are using

that would be me .

Its a simple process, all you have to do use is the computer management tool and create an indexing service.

If i add it as a linked server on an instance of SQL server on the same system it works.

when i try to access from a different system it gives me connection errors .

Known is handfull, Unknown is worldfull

 

[mrdenny]

Can you connect to the TCP port that the index service is listening on, on the remote machine?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[vbkris]

>>Can you connect to the TCP port that the index service is listening on

no idea how to do this! the indexing service runs currently on the same system. never knew that it used ports. how can i find the port that it uses???

Known is handfull, Unknown is worldfull

 

[mrdenny]

Is the service is setup for server to server connections then it has to have a TCP port open for a remote connection.

As you are the one how wrote the indexing software you would have had to specify it within the source code.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[vbkris]

hey,

I have not written any software. windows provides it inbuilt. You can set one up using computer management tool in the system. unfortunately you can index only those files in the same system unless the systems have shared drives...

Known is handfull, Unknown is worldfull

 

[LFCfan]

vbkris,

I have the same problem, have you uncovered any secrets yet?

Thanks

~LFCfan
dupGo5P0eQzp0dsJHG5O9tTf7Bx0hV08pisv
The above information is locked. Chance has the key.

 

[LFCfan]

I have now got a little further, by using the syntax

Select Filename, Rank, VPath, Directory, DocTitle	from [b]RemoteServerName.Documents..SCOPE()[/b]	where FREETEXT(''library'')	ORDER BY Rank DESC

I now get an access denied error:

OLE DB provider "MSIDXS" for linked server "Documents" returned message "Invalid catalog name 'DOCUMENTS'. SQLSTATE=42000 ".
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "MSIDXS" for linked server "Documents" reported an error. Access denied.

My linked server is set up so that connections are made using a valid login, so I'm not sure what to do next....


~LFCfan
dupGo5P0eQzp0dsJHG5O9tTf7Bx0hV08pisv
The above information is locked. Chance has the key.

 

[vbkris]

hi LFCfan,

no go till now

Maybe you could share the drives in your case across systems. that will ease it up a lot...



Known is handfull, Unknown is worldfull