June 15, 2006 at 11:49 am
I set up a linked server and it is working great......when i'm logged in under the same account that SQL runs under (also the account that i set up the linked server as, if it matters). However, if i'm logged in as anyone else i get the error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'VFPOLEDB' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IUnknown::QueryInterface returned 0x80070005: Access denied.].
It even does this with my account (full sql and domain admin). Help!
June 18, 2006 at 9:14 am
How is the security delegation for linked sql server configured?
Always login using with the user context, always connect with this account ....?
June 19, 2006 at 8:00 am
made without using a security context
thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply