November 2, 2006 at 1:23 pm
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
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply