Could not execute query against OLE DB provider MSIDXS

• rschaeferhig

  SSCrazy Eights

  Points: 8776

  More actions

  May 11, 2004 at 9:02 am

  #76161

  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?

   

   
  
  

• icewharf

  Grasshopper

  Points: 24

  More actions

  July 2, 2004 at 12:21 am

  #513074

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

   

• Grey Randall

  Newbie

  Points: 9

  More actions

  May 16, 2008 at 8:09 am

  #816514

  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?