We have a database that has a view with an openquery to a non-windows server running DB2. The view works fine with AD users that are in the sysadmin role, but user in the public role for the server and dbo or datareader on the database get an access error. The view also works fine with SQL users that are in the public role on the server and either dbo or datareader on the database level. Please see the attached error message.
To my eye, this has to be an issue with running openquery on a non-windows server with AD user accounts. I have looked around and can't find an answer.
We are running SQL server 2008 R2