Re: Remote Indexing Server - authentication problems

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

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: Error attempting to execute a DTS package from an ADP
    ... That login is a domain account with the correct privileges. ... I have tried saving the file to a directory on the application server ... changing the user ID that the SQL Server Service runs as to my own ...
    (microsoft.public.sqlserver.dts)
  • Re: Remote Indexing Server - authentication problems
    ... This should be on your remote Index Services server. ... Looking for a SQL Server replication book? ... Query Analyzer on the DB server (using a domain account) works fine. ... I feel it has something to do with security account delegation, ...
    (microsoft.public.sqlserver.fulltext)
  • RE: problem connecting to dbase from webservice with impersonation
    ... will acess a remote SQL Server instance, so you want to let your ASP.NET ... application run under a domain account so as to access the remote SQL ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: IIS 6 CreateObject premissions issue
    ... >> tier system so I am confident that running on Windows 2000 what I am ... >> What I am attempting is to add a Windows 2003 server box to function as ... However if it is set for anonymous access using the ... >> end boxes to specifically allow the Domain account I attempted to use as ...
    (microsoft.public.inetserver.iis.security)
  • Re: Networking XP Pro to a Downlevel NT4 domain
    ... There are two ways to create a domain account on an NT4 ... domain - the first is to run Server Manager either from ... >We are not running DCHP here. ...
    (microsoft.public.windowsxp.network_web)