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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment