如何查询远程索引目录

发布于 2024-11-12 23:10:19 字数 696 浏览 7 评论 0原文

我一直在尝试在 SQL Server 中创建一个链接服务器来访问远程索引服务目录，但我似乎无法做到这一点。我们打电话吧远程服务器“remoteServer”和目录“remoteCatalog”

我尝试过：

EXEC sp_addlinkedserver remoteIndexServer, 'Index Server', 'MSIDXS',
    'query://remoteServer/remoteCatalog'

然后我确实运行了 SQL

SELECT * FROM OPENQUERY(remoteIndexServer,'select filename from scope()') AS Q

但我得到了错误

OLE DB provider "MSIDXS" for linked server "remoteIndexServer" returned message "Service is not running. ".
Msg 7320, Level 16, State 2, Line 3
Cannot execute the query "select filename from scope()" against OLE DB provider "MSIDXS" for linked server "remoteIndexServer".

原文

I've been trying to create a linked server in SQL Server that accesses a
remote Index Service catalog, but I can't seem to do it. Let's call
the remote server "remoteServer" and the Catalog "remoteCatalog"

I've tried this:

EXEC sp_addlinkedserver remoteIndexServer, 'Index Server', 'MSIDXS',
    'query://remoteServer/remoteCatalog'

and then i did run the SQL

SELECT * FROM OPENQUERY(remoteIndexServer,'select filename from scope()') AS Q

But i got the error as

OLE DB provider "MSIDXS" for linked server "remoteIndexServer" returned message "Service is not running. ".
Msg 7320, Level 16, State 2, Line 3
Cannot execute the query "select filename from scope()" against OLE DB provider "MSIDXS" for linked server "remoteIndexServer".

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

痕至 2024-11-19 23:10:19

我以前经历过这个问题。这是凭记忆写的，所以请原谅任何错误，但如果我没记错的话，您将需要执行以下操作。

在本地 SQL Server 上安装索引服务（以便提供程序可用）。

将链接服务器添加到此 LOCAL 索引服务。

然后，您可以按如下方式运行查询。

SELECT * 
FROM   OPENQUERY(
           LocalLinkedServer,
           'select filename from RemoteServer.CatalogName..scope()'
       ) AS Q

如果这不起作用，请告诉我，某处有一篇文章描述了如何执行此操作。如果需要的话我可以查一下，但我认为上面是对的。

I have experienced this issue before. This is from memory so excuse any errors but if I recall correctly you will need to do the following.

Install the indexing service on your local SQL Server (this is so the provider is available).

Add a linked server to this LOCAL indexing service.

You can then run you query as below

SELECT * 
FROM   OPENQUERY(
           LocalLinkedServer,
           'select filename from RemoteServer.CatalogName..scope()'
       ) AS Q

If that doesn't work let me know, there is a post somewhere that describes how to do this. I can look it up if necessary but I think the above is right.

回复收藏 0 原文

~没有更多了~