Linked server to FoxPro - permissions

you'd want to specify the remote login and how local login is mapped.
--Everyone connects via Admin db user
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:AF38060C-1BCB-4A83-86BE-A04068521894@.microsoft.com...
>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::QueryInterfac
e
> returned 0x80070005: Access denied.].
> It even does this with my account (full sql and domain admin). Help!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!|||you'd want to specify the remote login and how local login is mapped.
--Everyone connects via Admin db user
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:AF38060C-1BCB-4A83-86BE-A04068521894@.microsoft.com...
>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::QueryInterfac
e
> returned 0x80070005: Access denied.].
> It even does this with my account (full sql and domain admin). Help!|||doesn't that map logins from sql server to remote(foxpro) logins? I don't
believe there is any sort of security on the foxpro database (not even sure
that they're capable of that).
If I'm wrong about any of that, please let me know.|||doesn't that map logins from sql server to remote(foxpro) logins? I don't
believe there is any sort of security on the foxpro database (not even sure
that they're capable of that).
If I'm wrong about any of that, please let me know.|||ha can help me out in my prob ...? check out Ravi --> primary Key falling
short sorry for this ..!|||ha can help me out in my prob ...? check out Ravi --> primary Key falling
short sorry for this ..!|||most jet engine has an 'admin' login.
either:
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
or
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, NULL, NULL
should work for vfp. The key is in the 'false' parameter. It tells sql not
use the current executing user credential for accessing vfp.
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:6D4C43C2-8EFA-4109-BF77-4D1ADE7746D6@.microsoft.com...
> doesn't that map logins from sql server to remote(foxpro) logins? I don't
> believe there is any sort of security on the foxpro database (not even
> sure
> that they're capable of that).
> If I'm wrong about any of that, please let me know.|||most jet engine has an 'admin' login.
either:
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
or
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, NULL, NULL
should work for vfp. The key is in the 'false' parameter. It tells sql not
use the current executing user credential for accessing vfp.
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:6D4C43C2-8EFA-4109-BF77-4D1ADE7746D6@.microsoft.com...
> doesn't that map logins from sql server to remote(foxpro) logins? I don't
> believe there is any sort of security on the foxpro database (not even
> sure
> that they're capable of that).
> If I'm wrong about any of that, please let me know.|||Tried both, to no avail.........any other ideas?
Thanks!
"oj" wrote:

> most jet engine has an 'admin' login.
> either:
> EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
> or
> EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, NULL, NULL
> should work for vfp. The key is in the 'false' parameter. It tells sql not
> use the current executing user credential for accessing vfp.
>
> --
> -oj