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

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

  • Next message: Hilary Cotter: "Re: OLE DB provider 'MSIDXS' reported an error. Access denied." 
    Date: Mon, 20 Sep 2004 15:55:01 -0700

    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

  • Next message: Hilary Cotter: "Re: OLE DB provider 'MSIDXS' reported an error. Access denied."

    Relevant Pages

    • RE: 0x80004005 - you need permission to view its data
      ... When creating the Access linked server, make sure the data source using UNC ... the SQL server(Both SQL authentication and Windows Authentication work). ... 262177 How to enable Kerberos event logging ...
      (microsoft.public.sqlserver.security)
    • Linked Servers - Real Post
      ... I am running SQL 2k on Win 2k. ... a front end for our SQL database. ... added the linked server I want, and SQL queries it fine, ... leaving the "local server login to remote server login" ...
      (microsoft.public.sqlserver.programming)
    • Linked Server - Issue
      ... I have to access a Linked Server S2 (SQL 2000). ... In S1 I have setup a linked server using sp_addlinkedserver pointing to S2. ... Both MyAccount and SpecialAccount has access permissions to S2. ... Reason Not associated with a Trusted SQL ...
      (microsoft.public.sqlserver.programming)
    • Linked server and transaction
      ... I have an sp which queries data using a linked server. ... It shouldn't matter what the sp is because it's just a simple select from two sql server. ... The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. ...
      (microsoft.public.sqlserver.programming)
    • Re: Transfering only updated data (from as400 to SQL2000)
      ... Rifat, ... Create a linked server of the AS400. ... > will identify rows that require moving at ETL time. ... >> as400 to SQL. ...
      (microsoft.public.sqlserver.dts)