October 22, 2009 at 8:56 am
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, 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!
November 29, 2009 at 4:56 pm
By Definition that is not possible.
sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'
[ , [ @useself = ] 'TRUE' | 'FALSE' | 'NULL']
[ , [ @locallogin = ] 'locallogin' ]
[ , [ @rmtuser = ] 'rmtuser' ]
[ , [ @rmtpassword = ] 'rmtpassword' ]
[ @locallogin = ] 'locallogin'
Is a login on the local server. locallogin is sysname, with a default of NULL. NULL specifies that this entry applies to all local logins that connect to rmtsrvname. If not NULL, locallogin can be a SQL Server login or a Windows login. The Windows login must have been granted access to SQL Server either directly, or through its membership in a Windows group granted access.
November 30, 2009 at 2:31 am
Thank you for your answer!
Yep, unfortunately that's the case. Came to the same conclusion the day after, when reading BOL.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply