I've got the same problem here.

I dropped the linked server

Unchecked the Allow inprocess option.

Recreated the linked server by using query

Checked the Allow Inprocess option

Tested the query that failed at first time.

Result was not what I needed. So no help for me sofar.