Home » SQL ServerRSS

Linked Server Mapping Error "Access to the remote server is denied because no login-mapping exists"

SQL Server 2005 SP3 32bit server
Connecting to an Oracle 10g server
Loaded OracleClient 10g

I'm able to ping the Oracle Server, and ODBC connect and able to run an open query with a single remote user id.

Issue: When I use the security context "Be made using this security context" it connects.
When I choose the "Not Be Made" WITH THE SAME USER ID & PASSWORD, I get the mapping error.

 

8 Answers Found

 

Answer 1

When you select "Not Be Made" then it will not allow your connection to Oracle server  until you specify in Local server login to remote  server login mapping.

In my Scenario I select this option when certain users need permission to remote database.

I hope this will make clear about this error.

Thanks
Vishal

 

Answer 2

I enter the same user ID and password up top for the mapping  and it's like it doesn't recognize the entry in the mapping section.

This same mapping (userid) works on a 2000 server  going to the same Oracle server so I'm wondering if it's something in 2005 that is either a bug or a setting that is not turned on
 

Answer 3

I hope you are not mapping  windows users. If yes then you have to enable MSDTC service on both machines.

I had same problem with SQL 2005 on both ends. SQL authentication works fine for me without any problem.


Cheers
Vishal
 

Answer 4

Hi.   MSDTC is enabled.
I can connect via linked  server to another SQL server  using multiple user mappings.
The issue is when I link to an ORACLE server using multiple user mappings.

I can use the "Be made using this security context" and connect to the Oracle server, if I change the security option to "Not Be Made"  using THE SAME USER ID & PASSWORD I get a mapping  error.

Thanks,
Steph
 

Answer 5

Hi Steph,

I am using exactly what you are saying and it's working for me when I do "Not be made" and then map Local Windows User to SQL User on remote  machine.

I hope you are not imporsonating user while mapping.

Cheers
Vishal
 

Answer 6

Nope, I'm not impersonating.    It's really weird, I do that mapping  on a SQL to SQL linked  server and it works the way it should. 

But SQL to Oracle gives me the mapping error  unless I use the Be made using this security context.

 
 

Answer 8

When you select "Not Be Made" then it will not allow your connection to Oracle server  until you specify in Local server login to remote  server login mapping.

In my Scenario I select this option when certain users need permission to remote database.

I hope this will make clear about this error.

Thanks
Vishal


It is exactly what I need, It's good for reference, Now I understand more about it, Thanks for your effort!
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter