May 9, 2007 at 2:45 pm
Another update: After querying users and testing group memberships, I have found that:
A user with userAccountControl = NULL do not return in my memberOf query.
A user with userAccountControl of 512 shows up in my memberOf query.
Reading documentation shows values of 512 = Active and can Logon, and 514 = Disabled. Why or how would an account be NULL?
Thanks again!
May 11, 2007 at 1:51 pm
ISSUE RESOLVED.
It was a permissions issue. Messing with the local login, the login used on the Linked Server, and what the expected permissions were on the network were, I was finally able to find the right combination.
May 11, 2007 at 1:55 pm
Good Stuff Man!
I wonder if this would work in 2005 w/ the default Surface Area Configuration...
Cheers,
Ben
Ben Sullins
bensullins.com
Beer is my primary key...
December 9, 2008 at 2:06 pm
JuanBob...I'm having the same issue. How did you set the security for the linked server? For my Local Login, I used the domain administrator: domain\administrator. What should the remote user be? The same as the Local Login? And also, how do you check on AD to see if the MSSQLSERVER service account has permissions to query the directory? Thanks!
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply