Showing posts with label openquery. Show all posts
Showing posts with label openquery. Show all posts

Wednesday, March 7, 2012

Problem with remote index server (no result)

Hello,
from SQL Server 2005 I access a index server an another computer (cp-
tkl)
select * from openquery(IDXNAME, 'select filename from "cp-
tkl".idxc..scope()')
When I use windows authentification it works and I have a result. But
when I use SQL Server I have no result (and no error message). I try
some user mapping from the SQL User to the domain user (a user with
that works when I use windows authentication) in the security window
for the linked server, but I found no solution.
It look likes a simple authentification problem. What can I do?
Joachim
Give the everyone group full access to this registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Contro l\ContentIndex
"Joachim" <joachim.dehm@.gmx.de> wrote in message
news:1179465460.587412.54360@.n59g2000hsh.googlegro ups.com...
> Hello,
> from SQL Server 2005 I access a index server an another computer (cp-
> tkl)
> select * from openquery(IDXNAME, 'select filename from "cp-
> tkl".idxc..scope()')
> When I use windows authentification it works and I have a result. But
> when I use SQL Server I have no result (and no error message). I try
> some user mapping from the SQL User to the domain user (a user with
> that works when I use windows authentication) in the security window
> for the linked server, but I found no solution.
> It look likes a simple authentification problem. What can I do?
> Joachim
>