Re: OLE DB provider 'MSIDXS' reported an error. Access denied.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Barry Forrest (barry.forrest_at_no-spam.ps.net)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 10:27:04 -0700

How do I need to configure the remote server? Is there anything special I
need to configure on the IS catalog that I'm trying to access remotely?

I've execute the sp_addlinkedserver as you suggest, created the IS catalog
on the SQL box and I'm now getting the dreaded
Invalid catalog name 'CARENETWEB'. SQLSTATE=42000

The biggest problem is I haven't a clue what I'm doing, so thanks again for
the help.

Barry

"Hilary Cotter" wrote:

> The correct linked server command should be this
>
> EXEC sp_addlinkedserver Web,
> 'Index Server',
> 'MSIDXS',
> 'CarenetWeb'
>
> where CarenetWeb is a catalog on the local server.
>
> You can't build a linked server to a remote IS catalog, but you can query it
> like this
>
> Select * from openquery(LinkedServerName,'Select DocTitle, Vpath,
> Characterization from RemoteServerName.RemoteCatalogName..Scope() where
> FileName like ''%.txt''')
>
> Try the above and see if this solves your problem.
>
>
>
>
>
>
> "Barry Forrest" <barry.forrest@no-spam.ps.net> wrote in message
> news:ACAF9D1C-A2A1-42CE-8A34-57E6DE116A29@microsoft.com...
> > Not sure if I should post here of inetserver.indexserver, so I apologize
> > ahead of time.
> >
> > In Sql2000, I've added a linked server to a development box.
> > EXEC sp_addlinkedserver Web,
> > 'Index Server',
> > 'MSIDXS',
> > 'stjoedev01.CarenetWeb'
> >
> > I ran the same command on my local Sql box.
> >
> > When I execute this query
> > Select * from OpenQuery(web, 'Select DocTitle, vpath, Filename, Size,
> > Contents, characterization, PATH, URL, A_Href, rank, write
> > from stjoedev01.CarenetWeb..Scope(''"d:\Inetpub\"'')
> > where FREETEXT(Contents, ''adoption'') AND Rank > 50 order by rank desc,
> > write desc')
> >
> > on my local box I get a result set. When I excute the same query on the
> > development sql box I get the following error:
> >
> > Server: Msg 7399, Level 16, State 1, Line 1
> > OLE DB provider 'MSIDXS' reported an error. Access denied.
> > [OLE/DB provider returned message: Invalid catalog name 'CARENETWEB'.
> > SQLSTATE=42000 ]
> > OLE DB error trace [OLE/DB Provider 'MSIDXS' ICommandPrepare::Prepare
> > returned 0x80070005: Access denied.].
> >
> > In both cases the query analyzer session is logged in with dbo access.
> > I've
> > checked the file system catalog and "Everyone" has read/write access to
> > the
> > index files.
> >
> > The development sql instance is running under a local system account. My
> > local instance of sql server is running under a domain user account. Would
> > this account for the 'access denied'?
> >
> > My ultimate goal is to add a linked server to a production SQL box, but
> > it's
> > looking rather grim right now.
> >
> > Thanks for the help,
> >
> > Barry
>
>
>

Relevant Pages

  • Re: Performance problems -- need guidance on scaling
    ... Thanks for the update on the FT Catalog corruption, ... will use, up to a max of 512Mb, if this memory is available. ... a server with 512 MB of RAM and a resource_usage value of 5 ... the data, you could, detach your SQL 2000 mdf & ldf files ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Performance problems -- need guidance on scaling
    ... So we're now CPU ... I have read that putting the catalog and SQL table on separate RAID ... Our current server will support only a single CPU. ...
    (microsoft.public.sqlserver.fulltext)
  • SQL 2005 Express Connection Problem
    ... The remote site is not a company ... this remote site and try to log in I get this error: ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)