May 11, 2004 at 9:02 am
I'm trying to set up a linked server that can access a File System through the Indexing Service. I used the examples from Microsoft and I have a linked server defined using MSIDXS. I run the sample query they have in their article and I get the above error message. The MS article is at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp
The full text of the error message is:
Could not execute query against OLE DB provider 'MSIDXS'.
[OLE/DB provider returned message: Service is not running. ]
OLE DB error trace [OLE/DB Provider 'MSIDXS' ICommandText::Execute returned 0x80070002].
The Indexing Service is running. The scope I specified is included in the directories under the Indexing Service. I'm lost.
Any ideas?
May 14, 2004 at 8:00 am
This was removed by the editor as SPAM
July 2, 2004 at 12:21 am
The indexing service it's self has to be turned on first. Have a look at this guy's notes....
http://www.simongibson.com/intranet/indexserv/
I'd like to know how I can get SQL Server to look at an indexing service on a different server???
May 16, 2008 at 8:09 am
I have the exact same issue... SQL server is a separate machine, want to query the Index Server on our Web Server... Unfortunately, i get stonewalled at queries, and after a while, I get "linked Server returned message "Service is not running. " Even though I look at the server, and it is indeed running.
Has anyone come up with an answer to this in the last 4 years?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply