Sql Linked Server Query For Ad Returns Msg 7321

So I have a SQL query that pulls data from our Active Directory without any issues (slimmed way down for posting purposes): SELECT TOP 901 * FROM OpenQuery(ADSI, 'SELECT title, di

Solution 1:

So it appears this "Cross Forest SQL Query" doesn't handle external accounts too well - even if the account is granted Domain Admin. The solution was to get a local account on the trusted domain. Using that local account with the linked server did the trick. In my case, I'm using a separate linked server for each domain. I reckon there would be a more elegant solution, but it hasn't occurred to me yet.