Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
IIRC, try this. I think this is how I fixed it some time ago...
exec sp_configure 'Show Advanced Options', 1; reconfigure;
exec sp_configure 'Ad Hoc Distributed Queries', 1; reconfigure;
go
Edit, attempt 2:
Check this. I've seen this at a previous company (I wasn't sysadmin there) and can't remember what teh DBAs had to do for us to get our linked server to work (also Sybase)
