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
Hilary Cotter - 23 May 2007 14:08 GMT
Give the everyone group full access to this registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex
> Hello,
>
[quoted text clipped - 13 lines]
>
> Joachim