Re: Remote Indexing Server - authentication problems

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



try this one.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex

This should be on your remote Index Services server.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"vler" <VladaEric@xxxxxxxxx> wrote in message
news:1147853883.818222.291260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hilary, thanks for reply.

I tried (searched my registry for contentindexcommon and set READ
permissions to Everyone) but still no success.

What I further noticed is that the Windows authentication from the
Query Analyzer on the DB server (using a domain account) works fine.
The same user, but on application machine, the same error.

Maybe another hint, in SQL Profiler, the error looks somewhat diferent:

"Non-interface error: OLE DB provider MSIDXS returned
DBPROP_STRUCTUREDSTORAGE without DBPROPVAL_OO_BLOB being supported"

I feel it has something to do with security account delegation, but I
really cannot find the correct settings. I tried various mappings for
the linked server.

Do all 3 servers need to reside in the same domain? What user should I
set to run SQL Server service?

Did anybody have the same experience?

Thanks!



.



Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)