Thanks for trying to help. For some reason without making any changes, it started working. So that code is fine.

Hello, I have a similar problem. I implemented the suggested solution that queries AD without using a linked server and it worked great on my instance of SQL 2008...