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?
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 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy