Re: Linked server issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Girish (gbajaj_at_tietronixinc.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 10:23:14 -0500

My access database is password protected too. I tried the below and it does
not work. :(
It gives me a authentication failed error.

Girish

""Mingqing Cheng [MSFT]"" <v-mingqc@online.microsoft.com> wrote in message
news:lkuybiDhEHA.3636@cpmsftngxa06.phx.gbl...
> Hi Girish,
>
> From your descriptions, I understood that you would like to know how to
map
> SQL Server logins to the Admin account of the Access database. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know.
>
> I tested on my side following these steps:
> 1. Add a new linked server using SQL Server Enterprise Manager.
> 2. In the Linked Server Properties dialog box of SQL Enterprise Manager.
> Click the Security tab. Choose the Local login as "sa" and click on
> "Impersonate" and also choose the last option: "Be made using this
security
> context:"
>
> Remote login: Admin
> With password: <blank> -- leave this blank.
> (NOTICE that Access default Login is Admin and its password is NULL)
>
> It worked fine.
>
> Additionally, the following document might be helpful to you
>
> PRB: Error 7399 When You Run a Linked Server Query That Uses the OLE DB
> http://support.microsoft.com/?id=814398
>
> In sum, MAP here just means, the login name used must have the admin
> authority in Access system.mdw (default)
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
>
> Sincerely yours,
>
> Mingqing Cheng
> Microsoft Developer Community Support
> ---------------------------------------------------------------
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Relevant Pages

  • Re: Why Logon Prompt When you open a blank database?
    ... You always login when you start Access. ... login in as Admin, with no password. ... so you see the login prompt. ... > open a blank access database? ...
    (microsoft.public.access.security)
  • Re: MSAccess Permision problem PLEASE HELP.
    ... I cant use a Generic "WebUser" in the DB? ... >> I have an access database that has users, ... >> I can only get access to the tables if I login as georgel in the network ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Best Way to Change Password via the Web?
    ... remote users who use OWA and other web services here that require a NT login ... I plan on using the IISAdmPwd .htr files ... against my Access database they are forwarded on to the IISAdmPwd login ...
    (microsoft.public.windows.server.security)
  • Best Way to Change Password via the Web?
    ... remote users who use OWA and other web services here that require a NT login ... I plan on using the IISAdmPwd .htr files ... against my Access database they are forwarded on to the IISAdmPwd login ...
    (microsoft.public.inetserver.iis.security)
  • Best Way to Change Password via the Web?
    ... remote users who use OWA and other web services here that require a NT login ... I plan on using the IISAdmPwd .htr files ... against my Access database they are forwarded on to the IISAdmPwd login ...
    (microsoft.public.win2000.security)