RE: Linked server issue
From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 08/17/04
- Next message: Mueller-Lynch Thomas: "RE: BPA Feedback and Question"
- Previous message: Tibor Karaszi: "Re: List of highlighted non-keywords in Query Analyzer?"
- In reply to: Girish: "Linked server issue"
- Next in thread: Girish: "Re: Linked server issue"
- Reply: Girish: "Re: Linked server issue"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 09:00:03 GMT
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!
- Next message: Mueller-Lynch Thomas: "RE: BPA Feedback and Question"
- Previous message: Tibor Karaszi: "Re: List of highlighted non-keywords in Query Analyzer?"
- In reply to: Girish: "Linked server issue"
- Next in thread: Girish: "Re: Linked server issue"
- Reply: Girish: "Re: Linked server issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
