We replaced a physical server with virtual, I copied all the logins, and linked servers from the old server and restored all the databases from the old server to the new. Everything works fine except for a query that uses a linked server to query Active directory. I get a permission error:
The OLE DB provider "ADSDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation.
If I go to the linked server and test connection it succeeds. The linked server is set to connect to AD using SQLService. The only think that changed is the physical box we were running on, so it has to be something on the sql side that is not configured correctly?