Linked Server to MS Access DB: Login Mapping Error

From: Mark Johnson (no-reply@nospam.com)
Date: 08/27/02 

From: "Mark Johnson" <no-reply@nospam.com>
Date: Tue, 27 Aug 2002 11:43:56 -0400

I have a linked server connection set up right now in enterprise manager
called MYDB. It is pointing to an access database stored in
d:\test\mydb.mdb. The D:\ drive is a local drive on the server, not mapped
anywhere remote. The access database is not set to require any login
information to access the data.

In the [security/linked servers] section of Enterprise manager, for this
linked server, in the "Security" tab, I have the "Be made without using a
security context" option checked, and I have no usernames or passwords
listed at the top.

I am trying to access a table called "Customers" with this Query in Query
Analyzer:

===============================
SELECT * FROM MYDB...Customers
===============================

I get this error:

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

Please forgive me if this is a trivial solution. I am rather new to MS SQL
Server. Thank-you inadvance for your help!

- Mark

Relevant Pages

  • Re: How to do this?
    ... move the backend tables to the SQL Server and link the sql server tables in ... > typically one things of an Access database as either a relational database ... when you speak of splitting a frontend to an IIS ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Access database stability issues
    ... We have a front-end Access database file and the back-end Access database file with all the content. ... The back-end file is located on the server while the front-end is installed on 3 different computers in our office. ... Once we upgraded to SBS 2008, each client computer began experiencing occassional crashes due to the front-end losing its connection to the back-end file. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to do this?
    ... would return to questioning if a basic IIS server facing the public really ... to backaway from the technology a little bit to look at the business plan ... conditions on trying to front a website on an Access database that you have ... You would have IIS load of the SBS, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: To Web or to synchronize? That is the question.
    ... putting together an Access database and ASP, ... Jet replication is a really great tool if you have laptop users ... Server, and just host the app on a Windows Terminal Server in the ... the ASP solution and Lyle's SQL ...
    (comp.databases.ms-access)
  • Re: Slow response from Windows 2003 web server
    ... I am not sure which of these entries in the HTTPERR Logfile concerns my ... This is my simple test ASP script, ... What excatly do you mean by "Access Database - change in Windows Server ...
    (microsoft.public.inetserver.iis)