Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

SELECT spresults.* 
FROM OPENROWSET('SQLNCLI', 'Server=192.168.0.7;Trusted_Connection=yes;',
                ' Exec DBPharmaUltimus.dbo.uspMIS_ExportSalesData ''2015-07-28''') AS spresults

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Hello,

A pretty clear error message: In your connection string you use "Trusted_Connection=yes" to logon with Windows Authentication and in your Scenario (Workgroup, untrusted Domain) this is not possible, you would have to use SQL Authentication instead.

You will need to explain why you think this should work.