none
Linked Server Mapping Error "Access to the remote server is denied because no login-mapping exists" Microsoft SQL Server Error: 7416

    Question

  • 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.

    Tuesday, January 19, 2010 3:55 PM

Answers

All replies

  • 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

    Tuesday, January 19, 2010 5:52 PM
  • 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
    Tuesday, January 19, 2010 7:06 PM
  • 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
    Wednesday, January 20, 2010 11:24 AM
  • 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
    Wednesday, January 20, 2010 5:29 PM
  • 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
    Wednesday, January 20, 2010 5:50 PM
  • 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.

    Wednesday, January 20, 2010 9:13 PM
  • Hi,

    I would suggest you to refer two links http://support.microsoft.com/kb/280106 and http://it.toolbox.com/blogs/daniel-at-work/linking-sql-server-2005-to-oracle-26791

    Regards
    Hemantgiri S. Goswami | http://www.sql-server-citation.com/ | http://www.surat-user-group.org/ -- Surat SQL Server User Group
    Thursday, January 21, 2010 10:25 AM