On a SQL Server 7 server, I have a linked server to a Sybase database server running this command:
select * from openquery(SYBASE_SERVER, 'select * from DBA.TESTTABLE')
works fine if I'm logged in as an SA.
If I try to run it while logged in as non-SA, it fails with the error:
Server: Msg 7302, Level 16, State 1, Line 1 Could not create an instance of OLE DB provider 'ASAProv.90'.
What permissions do I need to grant the user to let it work as a NON-sa account?