I am trying to add windows group ( MYDomainlogin) to the Linked Server security page, but when I click add --> then browse to find the windows group , I am not able to see this windows group. ( only see sql logins) . All windows group is working fine . I can ONLY able to see SQL Server logins in linked server secutiry add page. Can anyone let me know , is there any special way of setting windows group in linked server for impersonation. My goal is to have users in MydominQA_Group on 'Server_QA1' to access 'Server_QA2'. Any help is apprciated. Thanks
On the remote server, check if any Windows logins have been granted permission to log in explicitly. I would guess that implicit permission (granted to local admins, etc.) does not make the member logins show up in this list.
On the remote servers users who belong to their windows group , can easily log into the server , but the problem comes when these people ( who belong to windows group ) wants to access linked severs. Becasue of this reason, I would like to add them into linked server. Can you or anyone let me know, how should i deal with this problem. Thanks