February 15, 2004 at 7:46 am
Hai ALL
I am not able to access the data in ms access through Linked Server.
But if i logged in as "SA" i am able to access the data
I am using "four part name" method for accessing the data.
in the query analyzer it is giving the following error
Server: Msg 7416, Level 16, State 2, Line 1
"Access to the remote server is denied because no login-mapping exists."
Can anybody tell what permssion is required to access the data
please help
February 16, 2004 at 8:15 am
You said when you logged in as "sa" you were able to access the data. Are you using EM for this?
Are you logging into the QA with the same account (sa). Otherwise in the Linked Server properties, Security tab, add a user name and password under "Be made using this Security context". The user name and password are the authorized user name/password on the access. This would grant access to the access db for every login on the SQL Server.
February 16, 2004 at 9:21 am
If you haven't setup security on your access database the login is admin and the password is blank. Thoses are the defaults for access.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply