title: Advantage to SQL 2000 Linked Server Access Denied Error
body: <p>I am trying to create linked servers in SQL Server 2000 and SQL Server 2005 x64 to a Sybase Advantage database using the Advantage OLE DB Provider, 32-bit and 64-bit respectively.  </p>
  
  <p>I kept getting the following error when trying to browse the catalog and when performing a query with <strong>openquery</strong> from both SQL Servers:  </p>
  
  <pre><code>OLE DB error trace [OLE/DB Provider 'Advantage OLE DB Provider' IUnknown::QueryInterface returned 0x80070005:  Access denied.].
  Msg 7399, Level 16, State 1, Line 1
  OLE DB provider 'Advantage OLE DB Provider' reported an error. Access denied.
  </code></pre>
  
  <p>The following Stack Overflow question and answer helped me resolve this problem on SQL Server 2005 x64:  </p>
  
  <p><a href="https://stackoverflow.com/questions/4762415/advantage-to-sql-2008-linked-server-access-denied-error">Advantage to SQL 2008 Linked Server Access Denied Error</a>  </p>
  
  <p>However, I am still getting the <strong>access denied</strong> error in SQL Server 2000, despite setting <code>Allow inprocess</code> as suggested above.  </p>
  
  <p>Both linked servers use the same data source, login credentials and server options. Any help is greatly appreciated.</p>