Access from a Client in a Windows Workgroup

[pjw001]

Good Morning,

I have SQL2008 R2 running on an XP pc that is in a domain. On that pc is a VM that is in a Workgroup.

I need to access the Analysis Services on the host pc via a software package.

I have tried using Stored User Names but it does not work.

The software is able to create the two databases with the required entities, but it fails trying to update the datawarehouse. (The error message says that it had an error reading from a text file on the virtual pc.)

Any help or suggestions would be much appreciated.

Thanks.