EXEC master.dbo.sp_addlinkedsrvlogin with Windows Group possible?

• GordonLiddy

  Ten Centuries

  Points: 1047

  More actions

  October 23, 2009 at 12:00 am

  #216562

  Is it possible using Windows group instead of single Windows account to connect to another SQL Server via link?

  Trying to add a windows group (which is already a login/user in the server) as @locallogin returns the following error:

  Msg 15007, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 76

  'DOMAIN\My_Windows_Group' is not a valid login or you do not have permission.

  In our Active Directory the authenticated users are members of group DOMAIN\My_Windows_Group, e.g:

  DOMAIN\User1

  DOMAIN\User2

  ..

  And they can connect to the server, no issues there!

  Is this a NTLM/Kerberos problem, or anything else?!

  Thanks in advance!