Linked Server Login error 7416

• gam-199012

  SSC Veteran

  Points: 223

  More actions

  November 2, 2006 at 1:23 pm

  #62830

  I'm trying to set up a linked server between 2 sql2000 servers.  The local login for the linked server is a domain local group(LDG) that is sysadmin on the local server.  It is mapped to a remote SQL Server account(RA) with read only access to a specific database on the remote server.  When connected using a domain account(DA) that's a member of the domain local group(LDG), and trying to query the remote server, I get: Access to the remote server is denied because no login-mapping exists.(42000,7416).  

  If I change the local login to the domain account(DA), keeping all else the same,  the query works fine.

  The question is will Linked servers work using domain groups?  I haven't found much in researching this issue.  The only thing was this link from 2002.  It explains a similar situation in more detail.

  http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2002-06/0792.html