In Sql Server I have a linked Server connected to the Active Directory and this query to the foreign Security Principals:
SELECT Name, ADsPath, samAccountName, objectGUID, Manager
FROM OPENQUERY(ADSI,
'SELECT Name, ADsPath, samAccountName, objectGUID, Manager
FROM ''LDAP://cn=ForeignSecurityPrincipals,DC=SG,DC=PCM,DC=GOV,DC=PT''
') AS Rowset_1
Query Results records with the following format:
Name: S-1-5-11
ADsPath: LDAP://CN=S-1-5-11,CN=ForeignSecurityPrincipals,DC=sg,DC=pcm,DC=gov,DC=pt
samAccountName: NULL
objectGUID: 0x943F767C7855454F90B7663D5A900827
Manager: NULL
I updated the datasource in k2Server.Config with the trusted domain and restarted tehe service.
In Service manager, I can get users and groups for the first domain, nothing for the second (trusted domain). What am I doing wrong?