Problems with linked server

From: Al Blake (al_at__delete_this_.blakes.net)
Date: 03/15/05

  • Next message: Sue Hoegemeier: "Re: Rights for Access2000 Upsizing-Wizard" 
    Date: Tue, 15 Mar 2005 10:32:30 +1100

    I have a view in SQLDB A that is built out of a linked server that points at
    an Access (mdb) database.
    The linked database is set that security should make connections 'without
    using a security context'.
    This works perfectly for user sa. If I select from the view I get data.

    If I use another SQL authenticated user and make the same select I get:

    Server: Msg 7416, Level 16, State 2, Procedure uvTYarDuty, Line 2
    Access to the remote server is denied because no login-mapping exists.

    Why? As I said the linked server is set to use no authentication which is
    supposed to work perfectly for mdb databases....so why cant the non-sa user
    read the linked database?
    needless to say they have select permissions on the view itself.

    This is driving me crazy ;)
    Al Blake, Canberra, Australia

  • Next message: Sue Hoegemeier: "Re: Rights for Access2000 Upsizing-Wizard"

    Relevant Pages

    • Re: trying to create view on linked server
      ... > Linking only through the Access Project rather than OSQL or ... A linked server is a linked server. ... > to an external data source that you create in SQL Server. ... > table in an mdb. ...
      (microsoft.public.access.externaldata)
    • Re: trying to create view on linked server
      ... Linking only through the Access Project rather than OSQL or ... A linked server is a linked server. ... to an external data source that you create in SQL Server. ... In terms of your code and how it works with an mdb, ...
      (microsoft.public.access.externaldata)
    • Re: SQL 2005 linked server to Access 97
      ... I tried using Admin and '' that also did not work. ... using a linked server, it also does not work ON THE DEVELOPER EDITION ON WIN ... By any chance is the A97 mdb you're trying to link to secured using ...
      (microsoft.public.data.oledb)
    • Re: Crosstab Qry to ADP
      ... mdb as a linked server that will that will execute and return the result of ... Edit the mdb to, itself, have linked table to the original MS ... SQL Server (and sure, must have the crosstab pre defined, in the mdb). ...
      (microsoft.public.access.queries)
    • Re: Linking ADP to an MDB
      ... * Add the MDB as a linked server to SQL Server. ... Will support ... heterogeneous joins. ... Use ADO to connect to the MDB. ...
      (comp.databases.ms-access)