As part of security we have implemented groups and removed the individual logins from server and database.
but for linked servers access we are unable to add those groups. here if we are creating individual logins then only we can able to execute the linked server queries.
how can we add the groups to linked servers.we doesn't individual logins.
EXEC sp_addlinkedsrvlogin 'servername', 'false', 'domainusername', 'login', 'password'
i have executed the above query this is also creating the individual logins.
please help me out from this.